Conditional Formatting Codes Based On Cells

[Beefox]

i want to set a custom format code to have a cell not display its number if the cell above it contains the same value, for example
A1 = 300
A2 = 200
A3 = 200
A4 = 100

A1, A2. and A4 should be displayed, while A3 should not.

[mikekaganski]

[karolus]

Select A2:A? and go to →→Format→Conditional Format→Condition:

Cellvalue    |     equal to    |   A1
    <your Cellstyle with Formatcode: ";;;;"> (without the quotes)

[mariosv]

To make it also work with text, apply a style with the text in the background colour of the cell, usually white.