Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 07-03-2011, 03:24 AM
XpertOFFICE XpertOFFICE is offline help with conditional formatting Windows XP help with conditional formatting Office 2010 32bit
Novice
 
Join Date: Jul 2011
Location: UK
Posts: 3
XpertOFFICE is on a distinguished road
Smile Formula with relative addressing

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...
Reply With Quote
  #3  
Old 07-03-2011, 12:35 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline help with conditional formatting Windows 7 32bit help with conditional formatting Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

You can use the AND() worksheet function:

=AND(D6<40,E6>0)

It returns TRUE if both conditions are met.
Reply With Quote
  #4  
Old 07-03-2011, 11:55 PM
XpertOFFICE XpertOFFICE is offline help with conditional formatting Windows XP help with conditional formatting Office 2010 32bit
Novice
 
Join Date: Jul 2011
Location: UK
Posts: 3
XpertOFFICE is on a distinguished road
Default

Yes, thats nicer.
Reply With Quote
Reply

Thread Tools
Display Modes


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 02:21 PM.


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