Conditional Formatting

[Element121279]

In Column A I have formula's puling data from 12 other sheets. In column H I have a text list of all possible results from column A. I want to format column H if the data appears in column A.

Example...

A1 - 0
A2 - Bird
A3 - Fish
A4 - 0

H1 - Bird
H2 - Dog
H3 - Cat
H4 - Fish

I'd want Bird and fish to be formatted in column H & dog & cat to be normal.

 

[VoG]

Try the CF formula

=ISNUMBER(MATCH(H1,A:A,0))

 

[Element121279]

Perfect. Thank you!