Choose the type of conditional formatting

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.

Select the cells in the range A1:A50 and then click on Conditional Formatting | New Rule | Use a Formula ..., then put these formulae in:

=AND($B$1<>"",$C$1<>"",AND(A1>$B$1,A1<$C$1))

for condition (a) and this one for condition (b):

=OR(AND($B$1<>"",A1<$B$1),AND($C$1<>"",A1<$C$1))

For each one in turn, click the format button, then the Fill tab and choose your colour. OK your way out.

Hope this helps.

Pete

thanks arlu and pete,

pete suggestion solve my part of question. the real part of the question is how can i combine the condition (a) and condition (b) together become a single formula

@arlu: 1. if a and b is given a value for example, 20 and 80, then highlight the cells (in column A) which has the value in between these 2 number.
2. if only a or only b has value while the other left blank, then highlight the cells (in column A) which has the value lower than the number.
3. A1:A50 is filled with random numbers, while B1 and C1 are value(not text).