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

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" wrote:

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

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" wrote:

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" wrote:

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

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

"Acanesfan" wrote:



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" wrote:

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" wrote:

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

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


"FSt1" wrote:

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

"Acanesfan" wrote:



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" wrote:

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" wrote:

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