Add conditional formatting via VBA and loop through activesheet

**Andy15** · 04-19-2017, 06:14 AM

Hi guys,

Here's hoping somebody can assist in helping me modify an existing code shown below.
The current code adds some conditional formatting to an activesheet and is working great.

I need to add another bit of conditional formatting which is =AND(E22=B22,G22<D22/1.2)

The code needs to loop through the sheet and be added to every third column until the last column as the existing doc does

This is existing coed that is working great.

Please Login or Register  to view this content.

This is code I have tried to modify without any success

Please Login or Register  to view this content.

Many thanks for any help or advce

Post also added here https://www.mrexcel.com/forum/excel-...ml#post4806937

**dOOb** · 04-23-2017, 08:46 AM

Hi,

There is a closing bracket missing here:

Please Login or Register  to view this content.

There are two "(", but only one ")".
So update the last line to:

Please Login or Register  to view this content.

or better yet, to:

Please Login or Register  to view this content.

And that should do it.

**Andy15** · 04-23-2017, 10:17 AM

Hi d00b,

Thanks, that is what I needed. I can't believe that a missing ) caused so much hassle.

You are star

Works great.

Add conditional formatting via VBA and loop through activesheet

LinkBack

Thread Tools

Rate This Thread

Display

Add conditional formatting via VBA and loop through activesheet

Re: Add conditional formatting via VBA and loop through activesheet

Re: Add conditional formatting via VBA and loop through activesheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Add conditional formatting and loop through activesheet

To loop up Conditional Formatting

[SOLVED] For loop - Conditional Formatting

Loop within Conditional Formatting

VB Macro, FOR loop with conditional formatting

Conditional formatting in a loop

activesheet in loop

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions