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?
