software

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=quot;quot;,quot;quot;,IF('Program Tracker'!E16gt;=DATE(2006,3,3),IF('Program Tracker'!E16lt;=(DATE(2006,3,9)),quot;YELLOWquot;,quot;quot;)))

--------------------Where you see quot;YELLOWquot; 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: www.excelforum.com/member.php...oamp;userid=33650
View this thread: www.excelforum.com/showthread...hreadid=534250Conditional 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.
quot;akasterquot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; I am not looking into a VBA solution for this one and want to keep it
gt; simple. I want to enter a basic IF function/formula to make the color
gt; of a cell yellow if the condition is true.
gt;
gt; Here is where I am stuck/what I am putting inside the cell:
gt;
gt;
gt; Code:
gt; --------------------
gt;
gt; =IF('Program Tracker'!E16=quot;quot;,quot;quot;,IF('Program
gt; Tracker'!E16gt;=DATE(2006,3,3),IF('Program
gt; Tracker'!E16lt;=(DATE(2006,3,9)),quot;YELLOWquot;,quot;quot;)))
gt;
gt; --------------------
gt;
gt;
gt; Where you see quot;YELLOWquot; is where I need to put something in so it makes
gt; the active/current cell color yellow.
gt;
gt; Any suggestions would be greatly appreciated.
gt;
gt; Thanks,
gt; Robert Thomas
gt;
gt;
gt; --
gt; akaster
gt; ------------------------------------------------------------------------
gt; akaster's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33650
gt; View this thread: www.excelforum.com/showthread...hreadid=534250
gt;
Look in help for conditional formatting--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;akasterquot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; I am not looking into a VBA solution for this one and want to keep it
gt; simple. I want to enter a basic IF function/formula to make the color
gt; of a cell yellow if the condition is true.
gt;
gt; Here is where I am stuck/what I am putting inside the cell:
gt;
gt;
gt; Code:
gt; --------------------
gt;
gt; =IF('Program Tracker'!E16=quot;quot;,quot;quot;,IF('Program
gt; Tracker'!E16gt;=DATE(2006,3,3),IF('Program
gt; Tracker'!E16lt;=(DATE(2006,3,9)),quot;YELLOWquot;,quot;quot;)))
gt;
gt; --------------------
gt;
gt;
gt; Where you see quot;YELLOWquot; is where I need to put something in so it makes
gt; the active/current cell color yellow.
gt;
gt; Any suggestions would be greatly appreciated.
gt;
gt; Thanks,
gt; Robert Thomas
gt;
gt;
gt; --
gt; akaster
gt; ------------------------------------------------------------------------
gt; akaster's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33650
gt; View this thread: www.excelforum.com/showthread...hreadid=534250
gt;