Column I:I blue
 

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.

Column I:I blue
 

Select column I, FormatConditional Formattingchoose Formula as condition,
enter =A1<E1 in criterium, choose blue patternOK

Regards,
Stefi


€žSteved€� ezt Ã*rta:

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.

Column I:I blue
 

Hello from Steved

Thankyou

"Stefi" wrote:

Select column I, FormatConditional Formattingchoose Formula as condition,
enter =A1<E1 in criterium, choose blue patternOK

Regards,
Stefi


€žSteved€� ezt Ã*rta:

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.

Column I:I blue
 

You are welcome! Thanks for the feedback!
Stefi

€žSteved€� ezt Ã*rta:

Hello from Steved

Thankyou

"Stefi" wrote:

Select column I, FormatConditional Formattingchoose Formula as condition,
enter =A1<E1 in criterium, choose blue patternOK

Regards,
Stefi


€žSteved€� ezt Ã*rta:

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.