How would I get a row in my table to highlight if the date in the column F equals todays date. Note that more than one row can be lit up at once.

STEP 1: Select your table without headers (B24:G31 in image below). With selected table go to HOME->CONDITIONAL FORMATTING->New Rule... STEP 2: Select Use formula to determine which cells to format, enter formula: =$F24=TODAY(), choose desired formatting and press OK. RESULT:

Using conditional formatting to highlight a row if the date in the

Question posted 2014 · +11 upvotes

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.

Accepted answer +16 upvotes

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

Top `excel` Q&A (6)

Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
Convert xlsx to csv in linux command line +96 (2012)
How to create a link inside a cell using EPPlus +50 (2011)
IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
T-SQL: Export to new Excel file +44 (2012)

+16 upvotes ranks this answer #37 out of 167 excel solutions on this site — top 22%.

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

Question posted 2014 · +11 upvotes

Accepted answer +16 upvotes

Top excel Q&A (6)

Top `excel` Q&A (6)