You can set Excel 2011 for Mac to change the format of a cell, cell range, table, or pivot table based on conditions you specify. Use these settings when you want a cell’s appearance to change as the result of a formula or when someone types in a worksheet. Conditional formatting was improved in many ways for Excel 2011 for Mac. If you want to find only cells with a specific conditional format, start by clicking a cell that has that format. On the Edit menu, click Find, and then click Go To. Click Special, and then click Conditional formats.

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. So I think that to get the effect that you would like, you will need to use a macro to check the contents of the cell. A worksheet_change event should work well.

To get this code functional, I will need you to tell me the range of cells whose values should be hidden, and the range of cells that we are checking the values against. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range.Address Then For Each VariantValue in OtherRange If Range.Value = VariantValue Then Range.NumberFormat = ';;;' End If Next End if End Sub.