Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Conditional formatting to hide cell content even when printed

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):

Gray on gray still shows up

I am using Excel 2008 on the Mac.

like image 914
Jeff Erickson Avatar asked Mar 09 '11 15:03

Jeff Erickson


1 Answers

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

enter image description here

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

enter image description here

  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.

enter image description here

like image 107
mpalanco Avatar answered Sep 30 '22 00:09

mpalanco