Conditional Format in Excel

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
nmolliconiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dlmilleConnect With a Mentor Commented:
It should be:

=AND(O10<I10,I10>H10)

See attached.

cheers,

Dave
CONDITIONAL-FORMAT.xlsx
0
 
dlmilleCommented:
You have an error in your formula, shouldn't it be:

=O10<I10>H10

?

Dave
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.