CODEWITHSUNDEEP
excelconditional-formatting
methuselah
methuselah

Reputation: 13206

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

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.

Upvotes: 22

Views: 95937

Answers (2)

user2960847
user2960847

Reputation: 1

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

Upvotes: 0

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35853

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

Upvotes: 26

Related Questions