One way:

CF1: Formula is =OR(AND(A1=1,A1<=6),AND(A1=96,A1<=99))
Format1: <format


In article ,
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!