Conditional format row if time is present in one cell

[SimonHughes]

Hello, I would like to conditionally format the row where a time is present in any one of the Monday to Sunday cells (C3 to I3) so with 08h30 in cell C3 below, the whole row would be formatted (grey fill). Using MS 365.

A	B	C	D	E	F	G	H	I
Rider	Cat	Mon	Tue	Wed	Thu	Fri	Sat	Sun
NAME	BEL	08h30

Many thanks
Simon

 

[Joe4]

Let's say that your columns of entries for those days is C to I, and your first row of data entry is row 2.
Then, select all the rows you want to apply this to, starting with row 2, and enter this Conditional Formatting formula:

=COUNTA($C2:$I2)>0

and select your grey fill color.

 

[SimonHughes]

Let's say that your columns of entries for those days is C to I, and your first row of data entry is row 2.
Then, select all the rows you want to apply this to, starting with row 2, and enter this Conditional Formatting formula:

=COUNTA($C2:$I2)>0

and select your grey fill color.

That's it - works perfectly. Many thanks indeed Joe!

 

[Joe4]

You are welcome.
Glad I was able to help!