How do you Control the fill color using an if statement formula?
 

I'm trying to make an interactive calendar that will operate by changing the
fill color of the day. The user does this manually, but I want the formulas
in the sheet to read and react to this. I thought that I saw it before, but
I'm not sure how it was accomplished.

How do you Control the fill color using an if statement formula?
 

by the way, i'm running Excel 2002

"RussCrowder" wrote:

I'm trying to make an interactive calendar that will operate by changing the
fill color of the day. The user does this manually, but I want the formulas
in the sheet to read and react to this. I thought that I saw it before, but
I'm not sure how it was accomplished.

How do you Control the fill color using an if statement formula?
 

Hi,

You could use conditional formatting, for example, highlight the range of
dates and choose the command Format, Conditional Formatting and open the
first drop down and change to Formula is and in the second box enter
=C4=TODAY()
Where C4 is the active cell of the selection. Click the Format button and
choose a color on the Patterns tab.

--
Cheers,
Shane Devenshire


"RussCrowder" wrote:

I'm trying to make an interactive calendar that will operate by changing the
fill color of the day. The user does this manually, but I want the formulas
in the sheet to read and react to this. I thought that I saw it before, but
I'm not sure how it was accomplished.