Highlighting low quantities from Total

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.

conditional format u1 with
formula is =(T1-U1)<10
pick a colour from patterns
do the lot at once by higlhiting used cells in column
enter as above and all subsequent cells will be done
i.e.=(T2-U2)<10,=(T3-U3)<10
at the same time

Suppose the value 90 is in cell "U2"
select U2, then
Format > Conditional Fomatting
Cell value is greater than "=$T2-10" then
Choose your hilighter color
Then
copy and paste special > Format down to the whole range for TOTAL USED