| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| modifying name format within a cell | Excel Discussion (Misc queries) | |||
| Modifying format for multiple comments in a workbook | Excel Discussion (Misc queries) | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Multiple conditional on conditional format formula | Excel Programming | |||
| Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming | |||
Hybrid Mode
