View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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!