Thanks for replying. What I want is for values to appear based on X & Y, but to change colors based on Z.
Thanks for replying. What I want is for values to appear based on X & Y, but to change colors based on Z.
You need to change your formula.
=IF($D5>=E$2,IF($D5<=E$3,$C5,NA()),NA())
This will test for the values being between or equally to the min/max values.
If the difference value falls within the range you need to output the Y value rather than the difference value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks