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.
