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.
Select your table without headers (
B24:G31 in image below).
With selected table go to
HOME->CONDITIONAL FORMATTING->New Rule...
Use formula to determine which cells to format, enter formula:
=$F24=TODAY(), choose desired formatting and press OK.
If column A is just months and you want to show the annual rows then use the below formula
Don't forget to format you row