Hide value of cell if value same as other cell
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
|