Hello everyone,

I am using conditional formatting.
So I have a set of data, which range from 0 to 100 at cells A1:A50
I might need to highlight the values in between 2 figures or the highlight the values which is higher than a figure that I specified.
Is there a way to use conditional formatting such as:
(a) If B1 and C1 have figures (meaning B1 and C1 != ""), highlight all the values in between.
(b) If either B1 or C1 is inputed (meaning there is one cell is leave blank), highlight all the values which is smaller than the figure.

Thank you very much.