Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 805
methuselah Avatar asked Mar 11 '14 23:03

methuselah


People also ask

How do you highlight a row if a cell contains a date?

Click Format, under Fill tab of Format Cells dialog, choose one background color for highlighting rows. 5. Click OK > OK. Then relevant rows are highlighted if the cells in column C are in date format m/d/yyyy.


1 Answers

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

like image 188
Dmitry Pavliv Avatar answered Oct 26 '22 23:10

Dmitry Pavliv