Conditional Formatting
 

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

Conditional Formatting
 

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)

"Tdahlman" wrote:

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

Conditional Formatting
 

Thank you...That's perfect

"WLMPilot" wrote:

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)

"Tdahlman" wrote:

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