Conditional Formatting

[Guest]

I have a cell that I want to change the background color based on what the
value is. I can only use 3 conditional formats per cell. Is there a way to
say if the cell value is equal to either 1, 8, 9 or 18, then change the
background color?
It will eventually have to be up to 16 different numbers that will change
the background color of the cell.

Thanks in advance,
Travis

 

[Guest]

Choose the "Formula Is" option. Then insert the following as your criteria.
I will use A1 as the cell in this example.

=OR(A1=1,A1=8,A1=9,A1=18)

 

[Guest]

Thank you...That's perfect

Choose the "Formula Is" option. Then insert the following as your criteria.
I will use A1 as the cell in this example.

=OR(A1=1,A1=8,A1=9,A1=18)