If cell Value is (1) number, (2) smaller than Ref a, (3) is larger than Ref b;
Then apply specified background.
I have a storage of tons of these, and am about to setup yet another. I would like to clear all the existing formats.
All will be set to the default style.
“Then apply specified background.”
Please give us more details: How do you (want to) do it?
- By manual formatting,
- by applying some styles,
- by applying Conditional Format?