conditional formatting-different data to one color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of data that contains codes in the form of letters and
numbers. I would like to use conditional formatting to change the background
color of certain codes to one color, for example code A, f, J, 7 etc.( I have
about 15 of them) to a background color of red and leave the rest as they
are. Is there a formula I can use to do this? Any help would be appreciated.
Thanks.
 
Set up your conditional formatting so Condition 1 reads "Formula is"
in the dropdown, then paste this formula (or something like it) in to
formula field, then set up the formatter to paint the cell red.

=OR(C3=1,C3=2,C3=3,C3=4,C3=5,C3=6,C3=7,C3=8,C3=9,C3=10,C3=11,C3=12,C3=13,C3=14,C3=15)

Some of your codes are alpha characters, so you'll need to enter those
inside double quotes:
=OR(C3="A",C3="f",C3="J"...) etc.
 
Back
Top