Highlight cell between certain date

Question

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

Does the cell you want to format contain DDD m/d/yyyy? or is it split between two cells, as in DDD and m/d/yyyy? — Conquistador
@MattHead93 The cells that I want to highlight are in general format. But they are written manually in m/d/yyyy format. — user2572271

Conquistador Conquistador · Accepted Answer · 2013-07-12T07:31:55

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!

Highlight cell between certain date

1 Answers