Log In
Register
Home
Power Query
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
Power Query
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.
1 Guest(s)
