modifying conditional format

J

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?
 
C

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?
Click to expand...

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
 
J

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?
 
J

Jon Lea

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

CoRrRan

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

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
 
Top