Format cell color based on date range

Solved/Closed
Report
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
-
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
-
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

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014

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...!
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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.
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014

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