J
Jim
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 I’m 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
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 I’m 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