![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
djreyrey | Excel | 3 | 06-03-2011 01:54 AM |
Conditional formatting of Today +21 days? | SHERMAN | Excel | 3 | 12-20-2010 08:08 AM |
![]() |
Scaffold | Excel | 2 | 05-01-2010 08:56 AM |
Challenge!! Need help though. (Conditional formatting) | knuckles70 | Excel | 2 | 02-05-2010 12:24 PM |
Conditional Formatting to Hide Rows or Columns? | sczegus | Excel | 0 | 09-26-2006 04:17 PM |