Format cell color based on date rangeSolved/Closed

Question

Hi, this is my first post. 
I'm glad to be a member of this forum.

Based on conditional formatting, how can I select a cell and have the background color change to yellow if date range of another cell is for example, >= to 01/04/14 and <= 30/04/14...?

Thanks for any tips.....

Mazzaropi · Answer

doublewitt, Good afternoon. 

Welcome to this forum.

You can use a formula to activate a Conditional Formatting.

Suppose you can refers to C4
In your case a formula can be:
-->=MONTH(C4)=4
OK

Is this what you want?
I hope it helps.
 --
Belo Horizonte, Brasil.
Marcílio Lobão

doublewitt · Answer

Thanks for the response...

doesn't work,
Perhaps I should have mentioned that cell C4 refers to formula,  =TODAY()

Maybe we can avoid cell C4, and in the conditional formatting, we can directly include the TODAY formula. So if TODAY is within the month of April then cell yellow...

I hope this makes sense...!

Mazzaropi · Answer

doublewitt, 

The formula works anyway.

If C4 =today() or C4 =10/04/14, the formula works.
It's so simple.

But you you want to use no reference cell you can use:
=MONTH(TODAY())=4
It's the same thing.

Maybe you can show us your file to easier the answers.

doublewitt · Answer

At first, I entered it incorrectly - typed too fast...

But now I tried it just as you showed and it works just fine...!

Thank you

Format cell color based on date range

4 replies

Subscribe To Our Newsletter!