Conditional Formatting - Is this possible?
Conditional format the cell using formula is and then you wnat samething
like...
=NOT(ISNA(MATCH(A1, {1,2,3,4,5,6,7,8,9,95,96,97,98,99},FALSE )))
That formula checks the value of cell A1 against the numbers indicated.
--
HTH...
Jim Thomlinson
"Ash" wrote:
Is it possible to use conditional formatting for more than one set value?
For example, if a cell has a value of either 01,02,03,04,05,96,97,98, or 99,
I want to highlight the cell. I've searched the help function and the
website and don't see anything that specifically addresses this question.
Any help is greatly appreciated!
|