conditional formatting-different data to one color
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.
|