Conditional Formatting

T

Tdahlman

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
 
W

WLMPilot

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)
 
T

Tdahlman

Thank you...That's perfect

WLMPilot said:
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)
Click to expand...
 
Top