CODEWITHSUNDEEP
exceldateconditional-formatting
user2572271
user2572271

Reputation: 13

Highlight cell between certain date

I want to highlight the cell in excel sheet that are in between certain defined date. How to do it using conditional formatting?

I have selected the row that needs to be filtered and used conditional formatting, new rule and select "format only cells that contains" and entered date between Lets say Fri 7/12/2013 to Fri 7/19 and format it with one of the color.

This option worked and highlighted some of the cells but the problem is that it highlights that week dates but some other dates as well like Fri 8/16/2013

Upvotes: 1

Views: 5354

Answers (1)

Conquistador
Conquistador

Reputation: 362

I have managed to conditional format the dates (in American format, from UK system) as follows;

First, I ensured that the dates are formatted as yours. enter image description here

Then, I opened up the conditional formatting rule, and left out the = - note, here I had to input the UK format dates, you should be able to use your local format. enter image description here

Pressing OK, and then clicking back into the rule, it shows that leaving out the = has turned the date into a dateserial. enter image description here

Which then gives me the final product...

enter image description here

Let me know if you have any problems, or questions!

Upvotes: 1

Related Questions