Forum Discussion
Solved
Conditional Formatting in Table
OK, I'm confused. I have a table running, but the conditional formatting rule I'm using is affecting the whole table, not the row only. As there are 4 rules applying to one row, is there any way to...
Has been answered under Conditional Formatting Auto Update | Microsoft Community Hub by HansVogelaar
If you work with structured table and rules are applied to entire table, even if Apply To looks like $A$2:$F:20, conditional formating shall automatically expand on new rows appended to structured table.
If not, we need bit more details. Screenshot at least with table and rules defined.