Not really, but you want conditional formatting. See
http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"Excel learner" <Excel wrote in message
...
I am trying to put a spreadsheet together that will warn me if there is
only
20 % left of an order value i.e the order value will be in the top cell
and I
have got a invoiced to date where all the invoices are added up and then I
need to know the percentage left after whats been invoiced to date I hope
this makes sense to some1.,