help with conditional formatting

[Snvlsfoal]

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

[XpertOFFICE]

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

[Colin Legg]

You can use the AND() worksheet function:

=AND(D6<40,E6>0)

It returns TRUE if both conditions are met.

[XpertOFFICE]

Yes, thats nicer.