Thread: [Solved] help with conditional formatting
View Single Post
 
Old 07-03-2011, 12:35 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit 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.
__________________
Colin

RAD Excel Blog
Reply With Quote