Conditional Formatting Issue

[John Baker]

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

 

[Fernando Ortiz]

Hi Jhon

Build the condition without $ in the rows, the format conditional by default
work with absolute references.

Regards

Fernando Ortiz

 

[John Baker]

Fernando:

Thanks for your response

The condition is set as ="ar3<>0"

I don't have the $ in the formula. If i am supposed to use another form of reference, what
would I use to refer to ar3, and then have copy to the next row as ar4 etc?

Regards

John