Hi,
How can I have a sticky formula in conditional formatting across edits?
I am attaching a screenshot of it.
Initially, the formula in conditional formatting is number 1.
After I had added, edited, deleted rows, the formula becomes number 2 and number 3.
My family members being the user type, did not check the results, assuming it is still $B:$B, and thus some cells are not shaded.
Any idea how can I achieve this?
Thank.
How can I have a sticky formula in conditional formatting across edits?
I am attaching a screenshot of it.
Initially, the formula in conditional formatting is number 1.
Excel Formula:
=$F1="H", then shade green column $B:$B
After I had added, edited, deleted rows, the formula becomes number 2 and number 3.
My family members being the user type, did not check the results, assuming it is still $B:$B, and thus some cells are not shaded.
Any idea how can I achieve this?
Thank.