-1

I have a cell with a checkbox. I want another cell which contains a date to go green when the tick box is checked. I presume this is done in conditional formatting but I am struggling with it.

1

I have a cell with a check box. I want another cell which contains a date to go green when the tick box is checked.

You go to Format, Conditional Formatting and use the Custom formula:

=COUNTIF($D3, "=TRUE")

enter image description here

EXTRA:

On the other hand, if you want the whole range/column to be highlighted use the following formula:

=COUNTIF($B$3, "=TRUE")

Pay attention to the second $ sign.

enter image description here

  • 1
    @ChristopherGrant I am happy it worked out for you. As per site guidelines if an answer addressed your question, you should accept it so others can benefit as well -. (Why vote?) – marikamitsos May 23 at 5:21
0
  • if you have a scenario like shown on the image all you need is custom formula =B1=TRUE applied to range A1:A

    0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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