Hello,

I have a spreadsheet like this excel stuff.jpg and what i am trying to do is to create some conditional formatting where it will find the cell with "Break" in it and then change the colour of the cell with the time in it. so if its over 10min red, under 10min green.

I have tried to use

=AND($A$6:$A$30="Break", $D$6:$D$30<=00:10:00)

but that didnt work. Any suggestions?

Thanks

Andy