Ask Your Question

Conditional formatting- change cell's background colour when ANOTHER cell equal to... [closed]

asked 2017-09-12 19:21:09 +0100

appreciatethehelp gravatar image

updated 2020-09-23 13:32:44 +0100

Alex Kemp gravatar image

Hey guys.

So I am currently using conditional formatting on a basic spreadsheet to make the cell's background colour change when the word "yes" is shown as per the attached document: C:\fakepath\Conditional formatting example.ods

However, I would like the background of the adjacent goal to also turn green when "yes" is present in cell J2.

I am not sure how to make this happen, perhaps something along the lines of select cell A2 > format > conditional formatting > condition > (note, the next two options don't exist) other cell value is > specify cell(s) > apply style "Change cell background to green (3)

Since, as previously mentioned, the options "other cell value is > specify cell(s) don't exist, I need some help coming up with an alternative!


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-09-15 18:08:00.180898

1 Answer

Sort by » oldest newest most voted

answered 2017-09-12 19:40:29 +0100

JohnSUN gravatar image

It is possible that I misunderstood your problem. This method works for me

Example - C:\fakepath\Conditional formatting example.ods

Conditional formatting YES

edit flag offensive delete link more


Yes, that's the one! Am very grateful for that! Thanks.

Just a wee question; why is the dollar sign necessary in the formula $J2="yes" ?

appreciatethehelp gravatar imageappreciatethehelp ( 2017-09-13 05:58:28 +0100 )edit

Because checking the condition for cell A2, Calc will look whether there is a word "yes" in cell J2. And checking the condition for cell B2, C2 ... J2, he would look for the word "yes" in the offset addresses - K2, L2, etc.The dollar sign says to him: "Do not shift, look only at column J"

JohnSUN gravatar imageJohnSUN ( 2017-09-13 06:40:59 +0100 )edit

Understood, thank you! You have solved many of the long-term issues I have had; awesome!

appreciatethehelp gravatar imageappreciatethehelp ( 2017-09-15 18:07:43 +0100 )edit

Question Tools

1 follower


Asked: 2017-09-12 19:21:09 +0100

Seen: 26,124 times

Last updated: Sep 13 '17