modifying conditional format

[Jon Lea]

Hi.

I need to select a column of figures and modify the
formula of the first of three conditional formats. It
needs to be done in code as part of a sheet that formats
other spreadsheets.

Can anyone help?

 

[CoRrRan]

Hi.

I need to select a column of figures and modify the
formula of the first of three conditional formats. It
needs to be done in code as part of a sheet that formats
other spreadsheets.

Can anyone help?

Why don't you use the "record" option for Excel-macros? That way you can
check how Conditional Formatting is used through VB-code.

Or do you need specific information on this subject? I.e. you did use the
"record" function, but it isn't good enough for your problem.

CoRrRan

 

[Jon Lea]

I didn't use the record function. I've never used it
before so didn't know it would give me the relevant code.
Will it work even though the column number of rows can
change?

 

[Jon Lea]

Genius. I tried the recorder and it gave me the exact
code I needed for all conditions. Cheers!

 

[CoRrRan]

Genius. I tried the recorder and it gave me the exact
code I needed for all conditions. Cheers!

Glad to be of help. And remember this function of Excel, it is VERY VERY
usefull. Sometimes even for people who have been using VBA for a number of
years...

CoRrRan