How Do I Indicate Line Item Over Expected?

[MikeMcCollister]

For years, in my personal budget spreadsheet, I have listed a budget amount for a category and the actual amount spent. If the amount spent went over, I use conditional formating to color the number magenta.

I've never really liked this as it looks too much like a negative number, is not too obvious when printed out in black and white, and looks terrible if I make the alternating rows light green instead of gray.

I've dabbled with some ideas of putting an up arrow next to the number.

Is there a standard accounting way to display if a line item has gone over?

Thanks,

Mike

 

[frabulator]

Could you use conditional formatting to make it bold? That way it would show up when printed in black and white regardless of background.

 

[awoohaw]

You can try this, but you must format each cell individually, you can't copy CF with icon sets using relative references.

 

[MikeMcCollister]

You can try this, but you must format each cell individually, you can't copy CF with icon sets using relative references.

View attachment 107748




View attachment 107747

That actually looks pretty good but too bad I have to do one for each cell. I wish that I could do relative.

 

[awoohaw]

Well, maybe someone else will chime in with a way to do it.
Best wishes.