Conditional Format Against an Array Set 1

[gall3on]

Hi,

I'm trying to conditionally format a column of text cells where if the value belongs to a named range, it will highlight the cell.

Here's the example:

Column to Format
Dog
Catfish
Elephant
Goldfish
Betta Fish
Tiger

Mammals: Dog, Elephant, Tiger

So if the values under the column to format are found in Mammals, I want them to get highlighted.

Is this possible? Would this have to be done through VBA? How can this be achieved (VBA or not)?

 

[SkipVought]

Hi,

Put your mammals in a list and Name the Range, Mammals

In CF, Formula is: =Match(A1,Mammals,0)>0 assuming that A1 is the FIRST cell reference in the CF range.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[gall3on]

Thanks a bunch! It's been driving me crazy all day! Thank you Thank you Thank you!