Column I:I blue

  • Thread starter Thread starter Steved
  • Start date Start date
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.
 
Select column I, Format>Conditional Formatting>choose Formula as condition,
enter =A1<>E1 in criterium, choose blue pattern>OK

Regards,
Stefi


„Steved†ezt írta:
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX return multiple columns 1
Search between dates & return other column 8
if statement, change cell only if true 4
If Hours >0, If Volume <= 0,(and vice-versa) then.... 4
Need to count based on different criteria in two columns 3
My Duplicate formula is not functioning as it should 3
Help to to create a Formula or Macro 3
parsing a full name out into Last, First, Middle 2

Back
Top