Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This question already has an answer here:

I remember that I was able to make Excel highlight cells containing formulas with a different color, making easier to distinguish between calculated cells and cells where I manually entered data.

I recently switched to Mac and now I'm not able to find the same option on Excel 2011.

share|improve this question

marked as duplicate by teylyn, mpy, Mokubai, Tog, Michael Kjörling Aug 24 '13 at 19:15

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

There are several different methods of highlighting cells with formulas.

If you are using Excel 2007, follow these steps instead:

Press Ctrl+F3. Excel displays the Name Manager dialog box. Click New. Excel displays the New Name dialog box. In the Name field (at the top of the dialog box), enter a name such as FormulaInCell. In the Refers To field (at the bottom of the dialog box), enter the following:

=GET.CELL(48,INDIRECT("rc",FALSE))

Click OK. The New Name dialog box disappears, the Name Manager dialog box reappears, and the name you defined is listed in the dialog box. Click Close.

Now you can follow the techniques previously outlined for setting up the conditional formatting. The only difference is that the conditional format should check for the following formula, instead:

=FormulaInCell

This works in Excel 2010 as well (file must be saved as .xlsm) and I think it should work on Mac as it has same conditional formatting capabilities and macro support.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.