Conditional formatting to hide cell content even when printed
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...
- On the Format menu, click Cells, and then click the Number tab.
- Under Category, click Custom.
- In the Type box, type ;;; (that is, three semicolons in a row), and then click OK.