I have the dates listed down column A. Next to each date I have another four columns of data (columns B-E).
Right now I have it set up to highlight the date in column A when the day is today.
What I want to do is have all the cells in the date’s row highlighted when the date is today.
Is there a way to do this?
Yes of course; just do the same as you did for the date in column A.
Use the CF manager (>Format>Conditional>Manage…)
Edit the conditionak format comparing the date in column A with today’s date.
Set the ‘Range:’ to A1:AMU1048576 (all sheet).
Under ‘Condition 1’ choose ‘Formula is’.
Enter the condition $A1=TODAY().
Make sure to set the $ sign for the column name but not for the row number.
Choose the CellStyle you want to be overlaid.