View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
 
Posts: 99
Default 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