COnditional Formatting (from the Format Menu) is your simplest solution.
Set your conditions based on an absolute reference and a Formula Is if
you want to base the formatting from one cell:

Condition1 :

=if(AND($A$10,$A$1<.9),True,False)

where A1 is the cell that contains the percentage that sets the format
for the row (your "Last Box" as posted). use the Format... Font tab to
set the colour as required. Set the other conditions as required

You are limited to 3 conditions (Excel Limit I'm afraid); You could
write some VB that gets you around this based on events in a range on
the sheet - too much to detail here if you don't need it ...


--
optionbase1
------------------------------------------------------------------------
optionbase1's Profile: http://www.excelforum.com/member.php...o&userid=25212
View this thread: http://www.excelforum.com/showthread...hreadid=388910