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

excel conditional-formatting
methuselah picture methuselah · Mar 12, 2014 · Viewed 75.1k times · Source

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.

Answer

Dmitry Pavliv picture Dmitry Pavliv · Mar 12, 2014

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

Related questions

Conditional Formatting (IF not empty)

How do I conditionally format a cell so if not blank it is grey? I tried to do 'not equal', but it didn't work. I am using Windows Office 2003 with Windows XP at work. I don't see the same feature …

Read More
Change the color of cells in one column when they don't match cells in another column

I want to check if the values in one column are the same as values in another column. Whenever the values are not the same, I would like to change the color of these cells. For example: Column I, Column …

Read More
Conditional Formatting using Excel VBA code

I have Range object called DistinationRange which contains reference to range B3:H63 I want to apply the following two conditional formatting rules using Excel VBA code dynamically. (Because the range would not be same all the time) If Cell …

Read More