Need Excel Formula/Function to color cell interior
 

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

Need Excel Formula/Function to color cell interior
 

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.
"akaster" wrote in
message ...

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

Need Excel Formula/Function to color cell interior
 

Look in help for conditional formatting


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"akaster" wrote in
message ...

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