Need Excel Formula/Function to color cell interior

  • Thread starter Thread starter akaster
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

about "GET.CELL"(cel interior color) 1
How to Color a Cell Based on a Range of Cells with Colors 1
Cell Referencing 5
Too many IF functions 3
create a formula based on cell color 2
interior colored cells counting 3
Auto Change Formulas - Please Help. 2
Changing cell colors from a function command 3

Back
Top