0

I am trying to figure out why my range doesn't work when adding a conditional formatting rule in Google Sheets. I only get the formatting to work in one single cell.

I want to change format on a row with multiple cells if the cell in column C (in that row) is ="Deleted". I use the conditional formatting rule Custom Formula. I write =C11="Deleted" and the range (under the header Apply to range) A11:B11 or A11:B11, D11:K11 but it doesn't matter what I write, it only affects the first cell in the range (A11)

Why? What am I doing wrong?

I have tried to change the range and also tried to apply the formula in different rows and different sheet but I always get the same result...Only the first Cell in the Range is affected.

Custom formula is =C11="Deleted"
Range A11:B11

The formula works...I get the expected result but only affects the first cell in the range and not all the cells in the row that I want.

Improve this question

1 Answer 1

Reset to default
1

You need to "lock" the column in your formula, otherwise it shifts (interpreted as relative position) ==> =$C11="Deleted"

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

What is the easiest way to copy this formula to several rows? Now it works on one row.
Your "apply to" range should be A11:B or A11:B,D11:K so it keeps going after row 11 as long as it finds rows in those columns.
you're welcome, and likewise. Feel free to mark this topic as "resolved"/"answered" if you have no further question.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.