problem with Advanced Conditional Formatting

**Tnesper** · 06-17-2008, 06:52 PM

I’m having a problem with conditional formatting and was looking for some help.
I am trying to have excel highlight the entire row, of the top 20 values found in a specific column. I know how to write a formula so that it will highlight the entire row of, say, values over 300 in a specific column. But I don’t know how to do this with the top 20 values.

All I can get it to do is highlight the cell where the top 20 values are in, but I need the entire row that corresponds to those cells highlighted.

Any help?
Thanks

**Trebor76** · 06-17-2008, 10:23 PM

Hi Tnesper,

Have a look at tweaking the "Highest 4 numbers in a range" formula from here.

HTH

Robert

**Tnesper** · 06-18-2008, 10:31 AM

I got the formula working correctly, but it is still only highlighting the cell. I thought when you used the formula function of conditional formatting it automatically highlighted the entire row?

So now I have a successful formula, I just need to make it highlight the entire corresponding row of the highlighted cell.

**Tnesper** · 06-18-2008, 10:39 AM

Also, just to throw out an idea that I don't know anything about.

I thought that if there was a way to leave it alone so it is only highlighting the cells, but then write a formula somewhere that will say if, x cell is highlighted, then highlight x cells entire row. But again, I don't know if it is possible to write an if statement based on the conditional format of a cell.