Possible to loop formatconditions.formula across a defined range?

**mansfin** · 06-22-2015, 02:36 PM

Can I use the Offset property and loop variable (i) inside the "Formatconditions(1).Formula" IF statement like below? I have a feeling that I can't because I'm getting an application defined or object defined error (Run-time error 1004). Are there any other workarounds or suggestions?

Please Login or Register  to view this content.

**mansfin** · 06-23-2015, 09:54 AM

Will the .StopIfTrue property work?

Possible to loop formatconditions.formula across a defined range?

LinkBack

Thread Tools

Rate This Thread

Display

Possible to loop formatconditions.formula across a defined range?

Re: Possible to loop formatconditions.formula across a defined range?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If word entered not in defined name range, copy & paste it to bottom of defined name range

[SOLVED] Loop through a defined range within a defined range

Loop issues - Find value in range that fits value in defined name range

Loop through worksheets which are defined in a range of cells

help to create loop in a defined range

Bookmarks

Bookmarks

Posting Permissions