Conditional Formatting Question

Bean-Counter

New member
Joined
May 5, 2020
Messages
1
Reaction score
0
Points
0
Excel Version(s)
16
Good afternoon all,

I'm having a few issues with 'conditional formatting' I have it working partially!

What I'm trying to establish is when the date cell matches the current days date the whole row is highlighted. I can get the date cell highlighted but not the whole row.

Friday01/05/2020400.00
Saturday02/05/2020500.00
Sunday03/50/2020200.00

Hope this makes sense and thanks in advance
Clive
 
Select all of the columns that the CF is to apply to, not just one, and ensure the column is fixed in your formula, $B1=TODAY().
 
Back
Top