I have 2 similar worksheets with 12 columns and 1000 rows. Values in Column
K have a conditional format that highlights the cell in green if it is one of
the top 10 values in that column (on another worksheet it's if in top 20%).
I want the entire row to be the same format color, based on Column K. I
can't copy the format because some of the columns are in "," format, some in
"%" format, and so on. I'm not proficient enough in Excel to know how to
write this formula as a conditional format. Can anyone offer a suggestion or
solution to this problem?


Thank you.
A Canes Fan