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.
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.
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:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With