hi
I would like to know if there is a way I can evaluate 2 cells for
conditional formatting. For example if the value in h2 is lower than cell a1
and higher than c1 make h2 purple otherwise make h2 red.
I would like to know if this can be done using the conditional formatting
menu item. If not I am welcome to other suggestions.

Thanks in advance
geebee