Thanks, but unfortunately this wouldn't work for me. You see, the data I work
with is updated daily, so the rows change from time to time. if i choose E1
explicitly, it might not shade the cell correctly when the row number for
that line item changes.

"Bob Phillips" wrote:

Select all the cells in column A, starting at A1

Got to FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =$E120
Click the Format button
Select the Palette tab
Choose Red
OK
Click the Add button
Change Condition 2 to Formula Is
Add a formula of =$E113
Click the Format button
Select the Palette tab
Choose Orange
OK
Click the Add button
Change Condition 1 to Formula Is
Add a formula of =$E16
Click the Format button
Select the Palette tab
Choose Green
OK
OK

Also, see http://www.xldynamic.com/source/xld.CF.html#lights

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)