I have a spreadsheet in which each cell contains text or is blank. I want to apply conditional formatting on it so that iff a cell's text matches that of the cell immediately above it, then the cell appears to be blank (or gets merged with the immediately above cell). However, each cell is color coded according to the text which it contains, so I cannot actually clear it - it just needs to look that way. (I know that I can format it with ";;;" in order to appear blank, and that may be part of it)
- I do not know in advance what the text in each cell will be. I want all of the formatting to be applied automatically once the cells are filled. Someone else is going to fill in the cells in an unknown way; I want them to be able to do this without doing anything else; there will be no copying the cells or anything. (This person is not technologically capable, so I need to be able to make all of this stuff happen automatically in advance. They can type words, but that is it.)
- I do not want any dependence on any cell except the one immediately above the cell in question.
- Some columns may have text which repeats wrt the cells, but with
breaks (different texts) inbetween; I want to blank out a cell only
when there is a repeat value between adjacent cells when reading down the column - and the blanking out should apply only to the
later terms in a series of repeats, not the first one. For example,
if the entries in a column are of the form (A, B, A, A), then they
should appear of form (A, B, A, ) according to displayed text (but
the coloring should have all the "A"s one color (including the cell
in the fourth row/entry) and the "B" a different color).
Additionally, I want to end up counting how many apparently non-empty entries there are in each column after all of this.