Here is where the magic wand of conditional ... $60000 for the next year, you don’t need to set any rules. You can simply change the target value, and Excel handles formatting accordingly.
By smartly using cell borders, shading, data validation, and other formatting techniques, you can improve the visual appeal ...