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


--
akaster
------------------------------------------------------------------------
akaster's Profile: http://www.excelforum.com/member.php...o&userid=33650
View this thread: http://www.excelforum.com/showthread...hreadid=534250