Hi:

I have another "I need to do something but don't know exactly how" issue

I have a field which I wish to show up in red when the value of another field in the same
row changes from 0 to 1. This is clearly conditioning formatting, with a formula.

However this field is part of an extensive list, and I want to apply the same conditional
logic to all fields in the column on the list. The formula for a cell in row 140 would be"
=AR140<0". This works just fine on the single row 140. My problem is that I want this to
apply to all items in the table, and when I copy and paste, the formula always points to
AR140, rather than the row in column AR relating to the row the formula is copied to.

Is there some way to set up conditional formatting so that it can be copied to a bunch of
cells and have the formula point to the other cells IN ITS OWN ROW?

I hope I am clear on this.

Thanks in advance

John Baker