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

doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen - Apr 27, 2014 at 02:05 PM - Latest reply: doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen
- 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

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Apr 27, 2014 at 03:18 PM
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
doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen - Apr 27, 2014 at 03:47 PM
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...!
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Apr 27, 2014 at 10:53 PM
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.
doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen - Apr 27, 2014 at 11:04 PM
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