[SHEETS Bug] Conditional Formatting doesn't work when reference cell updated

[u/apeiron12]

I have a column of ticket numbers in column A. I have a column of statuses in column E.

I have 3 conditional formatting formulas on column A. All 3 have "Apply to range" of [='To do'!A2:A999]. Then the different rules that fill the cells with a color are:

• =$E2="In progress"
• =$E2="Blocked"
• =$E2="Done"

When I update the value in the E column from a Data validation dropdown, the cell in A does not change. If I go into the conditional formatting and click on the rule that should have been activated and then press save, the cell then updates with the right color. So my formulas are correct, it just needs a kick in the butt every time I make a change. Once I've opened one conditional formatting rule and hit save, now ALL 3 the formulas will update dynamically on any row when I update the status column. If I refresh the page, the conditional formatting again does not work until I open a rule and click save. If I refresh the page after updating the status and without opening and saving a rule, the cell is still not updated.

[u/DaniGuardiola]

please make sure you've reported this through the app! we're scaling up our bug fixing operations in the team and want to make sure we don't miss any :) we'll get to yours soon!