Column I:I blue

S

Steved

Hello from Steved

In Col A2 the number is 5543
In Col E2 the number is 5177
In Col I2 the Colour is Blue

As col A2 number is different from Col E2 then Colour Col I5 blue
yes if Cell A:A and Cell E:E have the same then ignore please.

I have over 2,500 row2 so please what is required.

I thankyou.
 
S

Stefi

Select column I, Format>Conditional Formatting>choose Formula as condition,
enter =A1<>E1 in criterium, choose blue pattern>OK

Regards,
Stefi


„Steved†ezt írta:
 
S

Steved

Hello from Steved

Thankyou

Stefi said:
Select column I, Format>Conditional Formatting>choose Formula as condition,
enter =A1<>E1 in criterium, choose blue pattern>OK

Regards,
Stefi


„Steved†ezt írta:
Click to expand...
 
Top