Macro to highlight cells according to condition

[Natsha]

I need to code an macro, where E column should highlight when its mismatches with the list of OMSIDS count ( column F) according to ticket ids(column B)

Example:
In ticket number: 2800876 , we could see in F column lists of OMSIDs are totally 3 but in OMSID count column, they have mentioned as 4 instead of 3 , which is wrong

Another ex: 2796053 , here totals OMSIDs are 10 but in OMSID count they mentioned as 9 which is wrong

So I need an macro where comparing the ticket id ( column B) along with lists of OMSID(coulmn F) , OMSID count (column E) should be highlight if there is mismatch in count

Likewise I have datas around 15,0000+ and been checking this manually till date,

kindly help, I have attached the sample sheet too

 

[vletm]

Natsha
One sample
... select cell E1 to run it.

 

[Natsha]

Hi,

It's working good... I was not aware that sheet has been saved as binary excel .
Thank you.. so much..

Need to know is there way we can do this in VBA macro?

 

[vletm]

Natsha
It's a VBA macro.
What is Your point?

 

[Natsha]

Okay....then i thought both are different

Thank you so much it's working