Conditional format row if one cell is in "top 10"

[Acanesfan]

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

 

[FSt1]

hi
a tad more info on the conditional fomating in column k would have been nice
but...
assuming the you are using "cell value" in column k, do this
in cell A1 enter....formula is.....=K1=your condition & format
you can enter this condition/format accross the row cell by cell so as not
to disturb your existing formats.
you can then copy the row and pastespecial formats down the sheet.

regards
FSt1

 

[Acanesfan]

A B C ...... K M
O
1 Name YTD DT % DT goal Hrly Rate Adj DT Target
2 Bowen 70.6% 85% 36.94 +5 66,153
9 Clark 81.0% 82% 56.48 +1 98,722

Here is an abbreviated picture of what rows 1 and 9 look like. To get the
conditional format in Column D I chose "Conditional formatting - highlighting
rules - "Format only top or bottom ranked values" - "format values that rank
in the [drop down menu] top" 10 [fill in] as green fill.

So in the example above, C2 is not in the top 10 values, but C9 is. On my
spreadsheet cell C9 is green. I would like to make all the cells in that row
be green. I can't copy the format, because some of the columns are
percentages, some are dollars, and so on. I entered the formula by using
drop down menus in the conditional formatting choices, and I don't know how
to put a formula in the other columns that says if $c9 is in Top 10, then
green fill, otherwise no fill.

I don't know how to enter a condition of "top 10" of a whole column. I tried
K1="Top 10" but that didn't work. So I tried K1="Top 10" K1:K360 and that
didn't work, either.

Does this help clarify?
Thank you.
A Canes Fan

 

[FSt1]

hi
apparently you are using 2007. another tip bit of info that would have been
useful.
the advise i gave concern 2003 and back. sorry. you are beyound my
expertice. perhaps a 2007 mvp can come along and supply what i apparently
cannot.
sorry.
perhaps you should visit this site.
http://www.cpearson.com/excel/newposte.htm

regards
FSt1

A B C ...... K M
O
1 Name YTD DT % DT goal Hrly Rate Adj DT Target
2 Bowen 70.6% 85% 36.94 +5 66,153
9 Clark 81.0% 82% 56.48 +1 98,722

Here is an abbreviated picture of what rows 1 and 9 look like. To get the
conditional format in Column D I chose "Conditional formatting - highlighting
rules - "Format only top or bottom ranked values" - "format values that rank
in the [drop down menu] top" 10 [fill in] as green fill.

So in the example above, C2 is not in the top 10 values, but C9 is. On my
spreadsheet cell C9 is green. I would like to make all the cells in that row
be green. I can't copy the format, because some of the columns are
percentages, some are dollars, and so on. I entered the formula by using
drop down menus in the conditional formatting choices, and I don't know how
to put a formula in the other columns that says if $c9 is in Top 10, then
green fill, otherwise no fill.

I don't know how to enter a condition of "top 10" of a whole column. I tried
K1="Top 10" but that didn't work. So I tried K1="Top 10" K1:K360 and that
didn't work, either.

Does this help clarify?
Thank you.
A Canes Fan

hi
a tad more info on the conditional fomating in column k would have been nice
but...
assuming the you are using "cell value" in column k, do this
in cell A1 enter....formula is.....=K1=your condition & format
you can enter this condition/format accross the row cell by cell so as not
to disturb your existing formats.
you can then copy the row and pastespecial formats down the sheet.

regards
FSt1

 

[Acanesfan]

Blush! I guess it's pretty obvious that this is my first post. I am going
to reword my question to include ALL of the appropriate information and try
again. I'm sorry for wasting your time.

Thank you.
A Canes Fan

hi
apparently you are using 2007. another tip bit of info that would have been
useful.
the advise i gave concern 2003 and back. sorry. you are beyound my
expertice. perhaps a 2007 mvp can come along and supply what i apparently
cannot.
sorry.
perhaps you should visit this site.
http://www.cpearson.com/excel/newposte.htm

regards
FSt1

A B C ...... K M
O
1 Name YTD DT % DT goal Hrly Rate Adj DT Target
2 Bowen 70.6% 85% 36.94 +5 66,153
9 Clark 81.0% 82% 56.48 +1 98,722

Here is an abbreviated picture of what rows 1 and 9 look like. To get the
conditional format in Column D I chose "Conditional formatting - highlighting
rules - "Format only top or bottom ranked values" - "format values that rank
in the [drop down menu] top" 10 [fill in] as green fill.

So in the example above, C2 is not in the top 10 values, but C9 is. On my
spreadsheet cell C9 is green. I would like to make all the cells in that row
be green. I can't copy the format, because some of the columns are
percentages, some are dollars, and so on. I entered the formula by using
drop down menus in the conditional formatting choices, and I don't know how
to put a formula in the other columns that says if $c9 is in Top 10, then
green fill, otherwise no fill.

I don't know how to enter a condition of "top 10" of a whole column. I tried
K1="Top 10" but that didn't work. So I tried K1="Top 10" K1:K360 and that
didn't work, either.

Does this help clarify?
Thank you.
A Canes Fan

hi
a tad more info on the conditional fomating in column k would have been nice
but...
assuming the you are using "cell value" in column k, do this
in cell A1 enter....formula is.....=K1=your condition & format
you can enter this condition/format accross the row cell by cell so as not
to disturb your existing formats.
you can then copy the row and pastespecial formats down the sheet.

regards
FSt1


:

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