Forum Discussion
Solved
Conditional Formatting Auto Update
So I have five Conditional Formatting rules based on a formula (example =$G$2="Escalated") to colour the entire row.
My issue is that I cannot get the rules to automatically update when new rows are added. It looks like there should be an INSERT option however I cannot get it to work. Can anyone help?
Example of the sheet below:
Change the formula to
=$G2="Escalated"
2 Replies
Change the formula to
=$G2="Escalated"
You, sir, are a God amongst men... this has been driving me mad for WEEKS!!!! Kicking myself that it was something so simple!
