VBA Code if this and that, then highlight both cells.

[ShwetaD]

Hi, Here's my dataset and I want to write a vba code such that

if AssetCondition="Fair" or "Fair-Good" And PlanType="Plan Type 3 - Capital Renewal" then highlight both AssetCondition and PlanType cells. I need to apply this rule to the whole sheet.

 

[ShwetaD]

The above code gives the error

 

[Trebor76]

What line is erroring out?

If it's this line...

lngRowTo = .Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

...it's most probably because there's no data on the tab used when setting the wsSrc variable (I used Sheet1 as an example). Ensure the tab the variable uses has some data and try again.

Not too sure beyond that I'm afraid as it works for me

 

[ShwetaD]

What line is erroring out?

If it's this line...

lngRowTo = .Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

...it's most probably because there's no data on the tab used when setting the wsSrc variable (I used Sheet1 as an example). Ensure the tab the variable uses has some data and try again.

Not too sure beyond that I'm afraid as it works for me

Yes it's on that line. I renamed the tab to Sheet1. Will check for data and run it. Thanks for the prompt response.

 

[Trebor76]

Isn't this a duplicate thread of this one? You should only post one thread per question.

 

[ShwetaD]

Isn't this a duplicate thread of this one? You should only post one thread per question.

Yes and No . It includes items 3 to 9 which I wanted to see if someone could help with. Didn't know if I could edit my question here so posted another one that is phrased to the point.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: VBA Code for Highlighting Cells based on If then Rules
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.