Notifications
Clear all
Excel Dashboards
2
Posts
2
Users
0
Reactions
45
Views
Topic starter
Is it possible to apply Conditional Formatting to a column in a table? When I paste more rows of data into the table, I'd like the conditional formatting to expand with the table.
Thanks!
Posted : 29/06/2016 7:55 am
Hi Andrew,
Yes, a table will automatically expand the conditional formatting as the table expands. You have to be careful that you don't paste your new data in and overwrite the conditional formatting rules. If you're copying and pasting data in make sure you Paste Special > Values.
Mynda
Posted : 29/06/2016 8:15 pm
