I have set up my conditional formatting to change text colors of a range of cells if a checkbox in that row has been checked.

However, this only changes text color of one of the cells.

Can anyone tell me why and has a solution to this?



Demo sheet:



enter image description here

1 Answer 1


Use this conditional formatting custom formula rule for the range B2:D:


See GimelG's explanation and Lance's explanation of how absolute and relative addresses work in a conditional formatting custom formula rule.

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.