DutchKevin
Board Regular
- Joined
- Apr 13, 2011
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
Hello All,
I've got 1 or 2 questions concerning Conditional Formats in Excel 2007. (CF for short in the rest of the post).
This is the situation.
On one sheet there are a some 10 area's on which I have applied multiple different CF's.
Now I'm faced with the issue that by copy pasting, and range extending several CF's now do the same thing, but cover equal or bigger ranges.
For sake of speed I'd like to decrease this, to cover only what is needed.
Modifying the CF's itself is not a big issue if it were a few or that the CF manager window was a lot bigger so I could have better overview.
Is there any way to:
- Make the CF manager window bigger?
- Show a birdseye view of the CF on a sheet displaying the various CF area's?
- Create some report on a seperate sheet mentioning all CF's and their parameters? I've seen the JWalk Chart Tool do such a report for charts in a sheet or workbook.
My second question is, if that's alowed in one post, that there is still an earlier post out there, posted by me, which was never realy solved.
What about running CF via named ranges through VBA?
As I have posted earlier, CF manager itself will translate any Named Range immediately into the hardcoded area.
Can it be such that a named range of any kind is defined in VBA or excel itself, and that the CF on that area is done through VBA rather then the CF manager?
Does anybody have suggestions for or experiences with such a setup?
See http://www.mrexcel.com/forum/excel-questions/637097-named-range-conditional-formats.html for the original post on that.
best regards
Kevin
I've got 1 or 2 questions concerning Conditional Formats in Excel 2007. (CF for short in the rest of the post).
This is the situation.
On one sheet there are a some 10 area's on which I have applied multiple different CF's.
Now I'm faced with the issue that by copy pasting, and range extending several CF's now do the same thing, but cover equal or bigger ranges.
For sake of speed I'd like to decrease this, to cover only what is needed.
Modifying the CF's itself is not a big issue if it were a few or that the CF manager window was a lot bigger so I could have better overview.
Is there any way to:
- Make the CF manager window bigger?
- Show a birdseye view of the CF on a sheet displaying the various CF area's?
- Create some report on a seperate sheet mentioning all CF's and their parameters? I've seen the JWalk Chart Tool do such a report for charts in a sheet or workbook.
My second question is, if that's alowed in one post, that there is still an earlier post out there, posted by me, which was never realy solved.
What about running CF via named ranges through VBA?
As I have posted earlier, CF manager itself will translate any Named Range immediately into the hardcoded area.
Can it be such that a named range of any kind is defined in VBA or excel itself, and that the CF on that area is done through VBA rather then the CF manager?
Does anybody have suggestions for or experiences with such a setup?
See http://www.mrexcel.com/forum/excel-questions/637097-named-range-conditional-formats.html for the original post on that.
best regards
Kevin
