Register
Log In
Unanswered
Home
New Member
June 21, 2017
Offline
Hello,
I have a table (created with CTRL+T) and some conditional formatting there.
When adding a new row there's no problem: the conditional formatting is expanded to that new row accordingly.
BUT, a user can also add a new column; and then the conditonal formatting is not expanded to that new column.
I know how to copy conditional formatting from one column to another, but not all users do (even if you explain it to them...)
So, if someone knows how to deal with this issue I would be very pleased (preferably not a VBA solution, because our company has strict rules).
Thanks in advance.
Martin
See Answer
July 16, 2010
Offline
Hi Martin,
Set up your Conditional Formatting rule and in the Applies To field extend the range to allow for growth in your table. If the user adds a column the format will be applied automatically.
Mynda
Answers Post
New Member
June 21, 2017
Offline
Hi Mynda,
and thanks for your reply.
That means that I have to calculate/estimate how many columns might be needed in the future, OK.
So obviously there's no way that the conditional formatting expands to new columns as it does for new rows.
Maybe this could be an enhancement request for the next Ecel Version 😉
BR
Martin
Mynda Treacy said
Hi Martin,Set up your Conditional Formatting rule and in the Applies To field extend the range to allow for growth in your table. If the user adds a column the format will be applied automatically.
Mynda
July 16, 2010
Offline
It would be nice if Conditional Formatting accepted dynamic named ranges, but for now it doesn't. You can make your suggestion on Excel User Voice. This is where the Excel team look for and prioritize new feature requests.
Most Users Ever Online: 57
Currently Online:
10 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
