Menu
Ask a question Report

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
Excel Ask a question Report
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

Report Respond to Mazzaropi
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
Report Respond to doublewitt
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...!
Report Respond to Mazzaropi
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.
Report Respond to doublewitt
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
Ask a question