I would like a cell to change color when a range of other cells all have a
value entered.
The cell I want to automatically format has the Sum function for a range of
cells in it. When the range of cells that are being being used for the Sum
function all have a value entered I would like the cell with the Sum to
change either background color or font color. Is there an easy way to do this?