Cond Formatting

[blackie42]

Hi,

Having trouble with the following...

If H2 = XXXX_3.4.4 cell J2 formats to CAT 2 and amber

But can't get it to work - tried several ways

Help please

thanks
Jon

[blackie42]

So the Colour formatting is easy enough

=H2="XXXX_3.4.4" and amber.

Thinking maybe a worksheet change in that column that adds CAT 2 if cells urn amber

[blackie42]

Achieved by nesting IF statements directly in the cell