Need Excel Formula/Function to color cell interior

A

akaster

Hello,

I am not looking into a VBA solution for this one and want to keep it
simple. I want to enter a basic IF function/formula to make the color
of a cell yellow if the condition is true.

Here is where I am stuck/what I am putting inside the cell:


Code:
--------------------

=IF('Program Tracker'!E16="","",IF('Program Tracker'!E16>=DATE(2006,3,3),IF('Program Tracker'!E16<=(DATE(2006,3,9)),"YELLOW","")))

--------------------


Where you see "YELLOW" is where I need to put something in so it makes
the active/current cell color yellow.

Any suggestions would be greatly appreciated.

Thanks,
Robert Thomas
 
A

Alan

Conditional formatting will do this for you albeit with only three options,
four including if no conditions are met. Look it up in Help, its a good
tool,
Regards,
Alan.
 
Top