Hi,
I'm doing up a spreadsheet, more like a Material Take Off, and there are several columns which includes the following:-
Column T Column U
Total Received Total Used
100 90
The Total Used is ongoing, meaning everytime I use a stock, it's added(Sum) automatically into the Total Used column.
If lets say I have 100 stock received, and I'm updating and I'm reaching to a point where I have a balance of 10, I'd like Excel to highlight in red that we are running low on this stock in the Total Used colum for each individual product. Is there a way to do it? Even if it means adding another column and excel highlighting in red to say we are >10 of that product.
Bookmarks