Forum Discussion
appstate98
Apr 26, 2023Copper Contributor
Conditional Formatting with a defined formula
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 t...
HansVogelaar
Apr 26, 2023MVP
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.
appstate98
Apr 26, 2023Copper Contributor
Thank you SO much!!