-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.

Improve this question

2 Answers 2

Reset to default
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

Improve this answer
1
  • 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, 2019 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

Improve this answer

Your Answer

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

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