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
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
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
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.
