I'm trying to apply conditional formatting to a sheet so that as a value is entered into each row of a specific column, that row would highlight. I'm able to do it for a single row using the formula =not(isblank($C3)), but then I can't copy that conditional formatting to the other rows since it's using an absolute reference. If I try using just =not(isblank(C3)) then only the first cell in the row ends up being formatted.

Here's an example of what I'm looking to do. As values are added to column C, the entire row would highlight.

  • Did you apply that formatting to the whole range? something like A2:C?
    – Daniele
    Jul 27, 2022 at 16:01

1 Answer 1

  • Create a Conditional formatting rule.
  • Set the Range as A2:C
  • Select "Custom formula"
    • =NOT(ISBLANK($C2:$C))



Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.