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
Bookmarks