View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default 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