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

[Special-K]

=(D3/E3>0.40)
format as required

Use Format Painter (paintbrush) to copy to other cells

[Fotis1991]

This looks to work..

=AND(ISNUMBER(D$1);D$2="Labor";E$2="Sales";D3/E3>0,4)

[rizmomin]

Hi Special-K:

I have 64 columns across and would need alternate column starting Column D to highlight and apply the above formula.
Is there an easy way to highlight these columns because manually choosing 32 alternate column is difficult and could lead to error.

Please let me know if any questions

Thank you

Riz Momin

[rizmomin]

Hi Fotis1991:

Thank you so much for your great help...this works.

Riz Momin

[Fotis1991]

Hi Fotis1999:

Thank you so much for your great help...this works.

Riz Momin

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

Also, PLS, Change the date in my name from 1999 to 1991, otherwise it will ask me (the forum) the consent of my guardian !