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?
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?