Conditional Formatting using IF and AND

[keepleft99]

Hello,

I have a spreadsheet like this Attachment 407088 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

[Special-K]

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