Forum Discussion
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 get the rule to automatically update with each new row, or would I have to create several hundred rules for each line?
Alternatively, if I were to create this outside of a normal table, same question; how would I get the conditional formatting to update for each row?
Has been answered under Conditional Formatting Auto Update | Microsoft Community Hub by HansVogelaar
5 Replies
Has been answered under Conditional Formatting Auto Update | Microsoft Community Hub by HansVogelaar
Learning excel more and more each day. Before I could download and just click on the ##### and it would change.however not with the version I am using for class.
You might be already doing this but are you using the desktop version?
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.
What do the rules look like?
