Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

I have a sheet that has conditional formatting that applies to column A:E. If I delete a…

  1. 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?

  2. 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(A2:A2:E2, ">10")

    Change it to:

    =COUNTIF(AA2:EE2, ">10")

    This will lock the formula to row 2 and prevent it from changing when you delete a row.