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 ?
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 ?
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.
-------------------------------------------------
The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.
Try Conditional Formatting
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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
Select E4, then use a formula
Thanks El XID