Hide value of cell if value same as other cell

[art]

Hello:

I have a chart from A1:H10. I want a code to check each row seperatly, if a
cell is equal with the same value of another cell on that row, it should not
show the result.

The problem is that the chart is all full of formulas, as it pulls the data
from somewhere else. So if I make a code that deletes the value, then I'll
lose the formula which I don't want. However, I was thinking of using a
forumla to check if the previous cell is the same, but I think it will make
the formula extremely long, which now is already very long (six rows long
formula).

Is it possible to write a code so it only "hides" the value, if a cell on
that particular row has already the same value? Of course one cell should
stay with that value visable.

Thanks, hope someone understands my question.

Art.

 

[Wouter HM]

Hi Art,

You can use ConditialFormat for the range B1:H10
In cell B1 add contdialformat using formula
=COUNTIF($A1:A1,B1)>0
Set the color for font to the same color as the background .

Next use the "Copy/Past format" brush to copy to the rest range
mentioned above.

HTH,

Wouter