modifying conditional format
 

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?

modifying conditional format
 

On Wed, 28 Jul 2004 03:22:00 -0700, Jon Lea wrote:

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

modifying conditional format
 

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?

-----Original Message-----
On Wed, 28 Jul 2004 03:22:00 -0700, Jon Lea wrote:

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
.

modifying conditional format
 

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

-----Original Message-----
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?

-----Original Message-----
On Wed, 28 Jul 2004 03:22:00 -0700, Jon Lea wrote:

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
.

.

modifying conditional format
 

On Wed, 28 Jul 2004 06:13:39 -0700, Jon Lea wrote:

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

-----Original Message-----
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?

-----Original Message-----
On Wed, 28 Jul 2004 03:22:00 -0700, Jon Lea wrote:

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
.

.


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