Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-01-2011, 08:36 PM
Snvlsfoal Snvlsfoal is offline help with conditional formatting Windows XP help with conditional formatting Office 2004 for Mac
Banned
help with conditional formatting
 
Join Date: Jul 2011
Posts: 9
Snvlsfoal is on a distinguished road
Default help with conditional formatting

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
help with conditional formatting * Conditional Formatting MS 2010 djreyrey Excel 3 06-03-2011 01:54 AM
Conditional formatting of Today +21 days? SHERMAN Excel 3 12-20-2010 08:08 AM
help with conditional formatting Conditional formatting of cell, Excel 2003 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft