Next Row after Condition is Met

[Analyze This]

Good Afternoon,

I have a report that is populated by a pivot table - within this ranking report are columns with RANK formulas. I want to "tell" Excel to underline the row after a condition is met, which will break the list into quartiles. Since there are formulas in the cells and not actual numbers, conditional formatting cannot be part of this process. Is there a way to make this work?

The pivot table will have varying number of rows, but will always have the same number of columns.

Anyone have an idea that will point me in the right direction please? Thank you!

 

[Oaktree]

Can you post a sample of what your data currently looks like and what you'd like the result to look like? (e.g. what is the condition? What cells are formatted as a result of the condition? etc.)

 

[Analyze This]

my computer refuses to allow me to download the tool to post my spreadsheet - the condition I'm trying to reach is when the rank number is at the 25, 50, 75 and 100 % range, I want a different colored line on the bottom of the cells.

Thanks!