Format cell color based on date range

Solved/Closed
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - Apr 27, 2014 at 02:05 PM
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - Apr 27, 2014 at 11:04 PM
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.....

4 replies

Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
Apr 27, 2014 at 03:18 PM
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
0
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014
Apr 27, 2014 at 03:47 PM
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...!
0
Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
Apr 27, 2014 at 10:53 PM
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.
0
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014
Apr 27, 2014 at 11:04 PM
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
0