help with conditional formatting

Joined
May 4, 2011
Messages
2
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top