Sunday, February 27, 2011

yogi_GroupOfCellsToChangeColorWhenAnotherCellHasX


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com


LADTHOMPSON said ...
I am trying to format a group of cells to change when another cell has an "X" input to it. 
How can I do this in google?

This works in excel through conditional formatting.  However, google does not have conditional formatting or I am not doing something right.  For example.  Cells "A2" through "G2" (all cells in the same row) have different text entered ranging from names to numbers.  What I want to have happen is when cell "H2" has an "X" input, I want those previous cells to either have the information formatted to "Strikethrough" or become a lighter color of text.


----------------------------------------------------------------------------------------------------------
The following workaround using Change color with rules in an adjacent row, say row 3 
might be of some interest to you. So here we go