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
|