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.


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.