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?
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
might be of some interest to you. So here we go
No comments:
Post a Comment