Shouldn't matter, the formula will update inline with the rows.

--
HTH

Bob

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

"Jonathan" wrote in message
...
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)