Have been trying to figure out on my own how to change the value in a cell once it reaches a negative balance. Would like it to change to red once the variance balance is less than -0. I am comparing a budget total to the actual spend for a given month.
Jan Feb
Budget $4,308 $4,308
Variance -$5,204 $4,248
In this example the -$5,204 should change to red to reflect we went into the negative for that month.
Mike
Bookmarks