How to add multiple conditions in a loop

[ThrottleWorks]

Hi,

Please check the attached file for details.


If B2 is Applicable and C2 is blank then highlight C2 with VB Yellow

I want to run this rule for hundreds of rows.

The problem is not how to apply this rule, the main condition is,

I need to check values in Column A

For example I will highlight Cell C2 from the range A2:C4

Once one cell is highlighted for A2:C4 I will not highlight Cell C4
Similarly I will highlight Cell C5 from range A5:C8 and will ignore cell C7

Column A consists of Account numbers, I need to highlight only one discrepancy per account And leave remaining as it is.

Can anyone please help me in this.

 

[Somendra Misra]

Hi Sachin,

See this file. Note the code is optimized for one sheet file only.

Regards,

 

[ThrottleWorks]

@Somendra Misra Sir, you are awesome ! Thanks a lot for the help.

Have a nice day ahead.

PS - The way you have used Count Ifs function is just awesome !
I was trying so many bizzare things to get this countif but could not achieve.

 

[Somendra Misra]

Glad you like the solution & thanks for your kind words. I think there will be a easy way out put these condition in the code. I had just translated what I would have done using formulas into code.

Regards,