Using conditional formatting to highlight a row if the date in the column F equals todays date

Question

How would I get a row in my table to highlight if the date in the column F equals todays date.

enter image description here

Note that more than one row can be lit up at once.

score 26 · Accepted Answer · answered Mar 12 '14 at 00:04

26

STEP 1:

Select your table without headers (B24:G31 in image below).

With selected table go to HOME->CONDITIONAL FORMATTING->New Rule...

enter image description here

STEP 2:

Select Use formula to determine which cells to format, enter formula: =$F24=TODAY(), choose desired formatting and press OK.

enter image description here

RESULT:

enter image description here

answered Mar 12 '14 at 00:04

Dmitry Pavliv

3

You can also do that without formulas - select "Highlight Cell rules" and then "A date occuring" and select "today" from the dropdown – barry houdini Mar 12 '14 at 00:27
1

@barryhoudini, absolutelly true! however using this approach it would be a problem to highlight _entire row_ based on value in column `F` – Dmitry Pavliv Mar 12 '14 at 08:32
1

OK, yes, for entire row you need the formula – barry houdini Mar 12 '14 at 11:49
1

Thanks @simoco! I don't know why Microsoft doesn't add a built-in rule to "highlight row or column based on the value of a cell". This seems like a really common usage. – Adam Porad Oct 14 '15 at 16:25

score 0 · Answer 2 · answered Sep 12 '14 at 14:38

0

If column A is just months and you want to show the annual rows then use the below formula

=MOD($A1,12)=0

Don't forget to format you row

answered Sep 12 '14 at 14:38

user2960847

2 Answers2