HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
BUTTON WOULD YOU LIKE TO DO

"Bob T" wrote:

I'd like to make a cell change color or the cell's font change color as the
number in the cell changes from negative to positive or vice versa?