Conditional Formatting - Everyones Bane

[KyleG]

I thought what i wanted would be simple but no matter how i do it i cant seem to get it to work.

I have a column (B) of times in the format [h:mm]. I want to hightlight non-normal hours.

Normal hours are 7:00 - 8:00 Monday to Friday. (Days listed in column A)
eg:
10:00 Monday - cell formatted.
No value Monday - cell formatted
No value Saturday - cell stays as normal
Any hours Saturday - cell formatted

thanks

 

[Bjornar]

Glad it worked fine for you.
Tought I just would throw in a note about the formula, to help you understand it. The part : $b4+$c4 , might seem a bit strange. It is the sum ot the two timevalues. So if no time is entered it will be 0, and if a time is entered in any of the cells it will be something else than 0. The conditional formula expects a true or false result, and converts 0 to false and any other value to true.