How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets?

Question

I would like to colour the background of a row in Google Spreadsheets:

For example:

If cell Dx = title 'To do' or 'title 'Done' then cells Fx to Nx are filled colour black.
If cell Dx = title 'closed' the font colour of cell Ax to Nx turns green.

I can do this in Excel quite easily...

As far as I know, such functionality has not been implemented in Google Spreadsheets. The only conditional formatting you can do is on the same cell with the value. — ale, Sep 13 '12 at 16:29

pnuts · Accepted Answer · 2014-02-18 00:19:02Z

1

Where x = 1, in New Google Sheets in Custom formula is please try:

=or($D1="To do",$D1="Done")

check Background:, choose black and for Range: enter F1:N1

add another rule with Custom formula is

 =$D1="closed"

check Background:, choose green and for range: enter A1:N1.

answered Feb 15 '14 at 14:36

pnuts

14.4k3 gold badges35 silver badges91 bronze badges

add a comment |

Bryan P · Accepted Answer · 2012-09-17 16:00:19Z

0

I wrote this web app - Color Code+ to cover most of the basic cases.

answered Sep 17 '12 at 16:00

Bryan P

1393 bronze badges

The example in your app, isn't editable. This way people can't see the result of your code: goo.gl/CFg61 – Jacob Jan Tuinstra Feb 6 '13 at 7:29
You have to make your own copy of it and then you can access the code. – Bryan P Feb 6 '13 at 13:24

add a comment |

2 Answers 2