Conditional Formating

[rizmomin]

Hello:

Please refer to attached sheet.

I have time range in column A and B.
For each time range, there is Labor cost and Sales information for each day.

I want to apply the conditional formating either by formula or VB Macro with condition as below.

Daily Labor & Sales info is in
column D,E for 1st day,
column F,G for 2nd day and so on..

I want to highlight the cell in column E,F,H and so on if labor cost for a given hour is greater then 40%.
To calculate the labor cost %, you would divide Labor Cost by Sales for a given hour.
Example :
D5/E5 = 0.37 which is below 40% that mean no highlight
H14/I14 = 0.53 which is above 40% that mean cell H14 needs to be highlighted.

Please help and let me know if any questions.

Thank you

Riz Momin