Column I:I blue

[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.

 

[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:

 

[Steved]

Hello from Steved

Thankyou

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

Regards,
Stefi


„Steved†ezt írta:

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Steved†ezt írta: