Conditional Formatting VBA Help

**ehizzlefosho** · 10-01-2018, 04:54 PM

CROSS POST FROM MR.EXCEL.COM https://www.mrexcel.com/forum/excel-...ml#post5153008

hello all,

I am trying to make a conditional formatting VBA code that will allow me to apply the same conditional formatting but with different values for every column. I am doing this so I can set it to repeat a number of times as determined by user input. For example I make 9 new columns and I want this same formatting for the value in the same row but new column. my main issue is making work Formula1:= activecell.offset(0,x), but I do not know how to do it.

Thanks in advance,

Eric

Please Login or Register  to view this content.

**Norie** · 10-01-2018, 05:02 PM

What are the formulas for the conditions you want to apply?

**ehizzlefosho** · 10-01-2018, 05:02 PM

I mainly would like to get Formula1:= activecell.offset(0,x) to work

**ehizzlefosho** · 10-01-2018, 05:03 PM

There are three conditional formatting rules I am using , a less than x, and greater than x, and between, x and y.

**Norie** · 10-01-2018, 05:14 PM

Are x and y fixed values or are they values in cells?

If you apply the conditional formatting manually what option would you use?

By the way, it's not really clear what you mean by using activecell.offset(0,x).

On its own activecell.offset(0,x) will return the value from the referenced cell, is that what you want?

**ehizzlefosho** · 10-02-2018, 08:03 AM

they are dynamic values. say that my active cell is Range("B9").Select , I would like the formula to equal hypothetically B3. I would like to offset this value because this code is meant to repeat a certain amount of times and offset the column by 1 every time it is repeated.

**ehizzlefosho** · 10-02-2018, 08:50 AM

Originally Posted by ehizzlefosho

they are dynamic values. say that my active cell is Range("B9").Select , I would like the formula to equal hypothetically B3. I would like to offset this value because this code is meant to repeat a certain amount of times and offset the column by 1 every time it is repeated.

To clarify, if this code starts at b9, and a conditional formatting rule reference b4. A macro will repeat twice and the first time around the code starts at c9 and should reference c4, and a second time starts at d9 and references d4, and so forth and so forth however many times I would like to repeat the process.

**ehizzlefosho** · 10-04-2018, 03:53 PM

Issue still unresolved *bump*

**ehizzlefosho** · 10-15-2018, 02:29 PM

Issue still unresolved *bump*

Conditional Formatting VBA Help

LinkBack

Thread Tools

Rate This Thread

Display

Conditional Formatting VBA Help

Re: Conditional Formatting VBA Help

Re: Conditional Formatting VBA Help

Re: Conditional Formatting VBA Help

Re: Conditional Formatting VBA Help

Re: Conditional Formatting VBA Help

Re: Conditional Formatting VBA Help

Re: Conditional Formatting VBA Help

Re: Conditional Formatting VBA Help

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Override conditional formatting (in general, without changing the conditional formatting)

Excel 2010 - Pivot Table conditional formatting - use multiple rows formatting on one row

Conditional Formatting Removing Previous Conditional Formatting?

[SOLVED] Keep conditional formatting results, but remove the conditional formatting?

Opening xlsm files with conditional formatting opens with removed conditional formatting

Conditional formatting based on conditional formatting of other cells?

Conditional Referencing Cell Ranges to avoid Conditional Formatting Cells Indvidually?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions