conditional formula
 

Hello,

Thanks in advance for the help.

I'm using a pivot table which is using columns A:N. In column O, I have
added related data that is conditional on one of the columns in the pivot
table.

In each cell of column O Im using the following formula:
=IF(N23="","",N23). I'm using this formula from row 23 all the way through
2000. I would like to format the row to match the borders of the pivot table
(using conditional formula).

1. What formula do I use in the conditional format box?
2. The formula should refer to column N. So that when the data in pivot
table ends, the formatting will also end.

I tried to be clear, I'm sorry if this question is not.

Thanks for the help.
Jim

conditional formula
 

I failed to mentintion, but you likely already know, that in a pivot table
blank fields need to be considered for the formula.

"Jim" wrote:

Hello,

Thanks in advance for the help.

I'm using a pivot table which is using columns A:N. In column O, I have
added related data that is conditional on one of the columns in the pivot
table.

In each cell of column O Im using the following formula:
=IF(N23="","",N23). I'm using this formula from row 23 all the way through
2000. I would like to format the row to match the borders of the pivot table
(using conditional formula).

1. What formula do I use in the conditional format box?
2. The formula should refer to column N. So that when the data in pivot
table ends, the formatting will also end.

I tried to be clear, I'm sorry if this question is not.

Thanks for the help.
Jim