Format cell color based on date range [Solved/Closed]

Posts
14
Registration date
Sunday April 27, 2014
Last seen
September 29, 2014
- - Latest reply: doublewitt
Posts
14
Registration date
Sunday April 27, 2014
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.....
See more 

4 replies

Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
0
Thank you
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
Last seen
September 29, 2014
0
Thank you
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
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
0
Thank you
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
Last seen
September 29, 2014
0
Thank you
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