gpt-3.5-turbo-0301· OpenAI
WildChat-4.8M (AI2)
I have a sheet that has conditional formatting that applies to column A:E. If I delete a…
- User
I have a sheet that has conditional formatting that applies to column A:E. If I delete a row, it upsets the conditional formatting formulas. Is there a way to stop this?
- Assistant
Yes, one way to stop this is to use absolute cell references in your conditional formatting formulas. To do this, add a dollar sign ($) before the row and/or column reference in the formula. For example, if your original formula was:
=COUNTIF(E2, ">10")
Change it to:
=COUNTIF(2:2, ">10")
This will lock the formula to row 2 and prevent it from changing when you delete a row.