Conditional formatting to hide cell content even when printed

Question

I would like to set up a conditional formatting setting that would hide the contents (the cell should look blank) if the cell's contents is equal to another cell. Does anyone know of a function to do this? I tried just making the font the same color as the background (gray, in this case), but unfortunately when this is printed, there is some sort of residue shadow left over from the text.

Here is what happens when I do gray on gray (they are supposedly the same color):

I am using Excel 2008 on the Mac.

Answer 1

Below in A2 we have the conditional formatting that hides the content of that cell if it is equal to B2.

In Conditional Formatting create the following rule: =$A$2=$B$2, then press Format...

1. On the Format menu, click Cells, and then click the Number tab.
2. Under Category, click Custom.
3. In the Type box, type ;;; (that is, three semicolons in a row), and then click OK.