PDA

View Full Version : IF Formula with colour



Gordon Scott
01-19-2007, 02:05 AM
i want to put an if formula into a spreadsheet to change certain cells to either red or green if i put yes or no into a certain column but remain white if not. Is this possible ?

JimmyTheHand
01-19-2007, 02:25 AM
I'm not sure but I think it's not possible via formula, except with a VBA coded custom function.
However, conditional formatting will work for you. It's in the Format menu.

mdmackillop
01-19-2007, 02:28 AM
Try Conditional Formatting

Gordon Scott
01-19-2007, 02:37 AM
Thanks but that only changes the cell you are working on. What i need is if i put either yes or no into cell B4 i want cell E4 to change to either red or green. If i cant do it with an if formula do you have a macro i could use.

Thanks

Gordon

Bob Phillips
01-19-2007, 02:59 AM
Select E4, then use a formula

Gordon Scott
01-19-2007, 03:04 AM
Thanks El XID