• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • Last Modified:

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
0
nmolliconi
Asked:
nmolliconi
  • 2
1 Solution
 
dlmilleCommented:
You have an error in your formula, shouldn't it be:

=O10<I10>H10

?

Dave
0
 
dlmilleCommented:
It should be:

=AND(O10<I10,I10>H10)

See attached.

cheers,

Dave
CONDITIONAL-FORMAT.xlsx
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now