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

Hi Jhon

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

Regards

Fernando Ortiz
"John Baker" escribió en el mensaje
...
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:

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


"Fernando Ortiz" wrote:

Hi Jhon

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

Regards

Fernando Ortiz
"John Baker" escribió en el mensaje
.. .
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