conditional formula


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
 
Ad

Advertisements

J

Jim

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top