Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Answer 1 / 4
Posts
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
 142
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
Answer 2 / 4
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...!
Answer 3 / 4
Posts
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
 142
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.
Answer 4 / 4
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
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!