We help IT Professionals succeed at work.

Conditional Format in Excel

nmolliconi
nmolliconi asked
on
Using conditional format in Excel and trying to incorporate a formula that will return yellow fill if the cell value is greater than a cell value but also less than another cell value.  Here is what I have (see attached)

Nick
CONDITIONAL-FORMAT.xlsx
Comment
Watch Question

Most Valuable Expert 2012
Top Expert 2012

Commented:
You have an error in your formula, shouldn't it be:

=O10<I10>H10

?

Dave
Most Valuable Expert 2012
Top Expert 2012
Commented:
It should be:

=AND(O10<I10,I10>H10)

See attached.

cheers,

Dave
CONDITIONAL-FORMAT.xlsx

Explore More ContentExplore courses, solutions, and other research materials related to this topic.