Forum Discussion

DON4711's avatar
DON4711
Copper Contributor
Jan 10, 2024

Conditional Formatting

Please help! I got this to work about 10 years ago but with copying/pasting to a new worksheet each year the format disappeared somewhere and I'm lost!   Columns as follows: Name, Opening Balance,...
  • mtarler's avatar
    mtarler
    Jan 10, 2024
    correct that is the problem. The formula is ONLY $D1=0. Basically the formula is based on ONLY the top left most cell. As Excel moves to other cells down or to the right it will internally update the formula ranges accordingly. So $D1 means always use column D but as Excel looks down at row 2 it will also use $D2 and some for row 3,4,.... but that is all internal. Write the formula as if you are doing it for the upper left cell ONLY but plan on copying/filling down/right.

Resources