Conditional Formatting with a defined formula

New Contributor

I am working on a spreadsheet that will highlight the length of a project for a builder. For example, if the renovation starts in week 1 and is estimated to last 10 weeks, the cells labeled weeks 1 through 10 are highlighted in the color for the designated project manager. The spreadsheet was shared with me from someone else. The rule for the conditional formatting says =Plan. However, I can't find "Plan" anywhere in the spreadsheet to see how the formula works. I've looked for hidden tabs, rows and columns, but can't find any. Does anyone have any suggestions for how I can find the "Plan" formula in the spreadsheet so I can make changes if needed? 

2 Replies


Activate the Formulas tab of the ribbon.

In the Defined Names group, click Name Manager.

Select Plan in the list of names, then look at the definition in the 'Refers to' box.

Thank you SO much!!