I am trying to add a feature to a payroll workbook the sheet looks like this:
ST OT CT
0.00 10.00 0.00
0.00 10.00 0.00
0.00 0.00 10.00

So what I need to do is highlight ST and OT if ST<40 and OT>0. I have tried using data validation for this problem as well as conditional formatting. the last formula I tried was
=if(d6<40,e6>0,) for the custom conditional formatting rules. Any suggestions here?



Thanks

Formula is:

=IF(F5 <40, IF(G5>0, TRUE, FALSE))



So F5 and G5 are the first cells of cols ST and OT. Apply this conditional formula (+ formatting style) to both F5 and G5. Select F5 and drag the copy handle (bottom right cell) down to all the cells in the column. Repeat for column G5.

XpertOffice...

You can use the AND() worksheet function:

=AND(D6<40,E6>0)

It returns TRUE if both conditions are met.

Yes, thats nicer.