Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format row based on conditional format of "Top Ten" in another cel
I am using Excel 2007. I have 2 similar worksheets with 15 columns and 100 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 just 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. 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. In the example below, K2 is not in the top 10 values, but K9 is. On my spreadsheet cell K9 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 $K9 is in Top 10 of $K$2:$K$100, then green fill, otherwise no fill. A B C €¦€¦ K M N 1 Name YTD DT % DT Goal Hrly Rate Adj DT % New Target 2 Bowen 70.6% 85% $36.94 + 5% $66,153 9 Clark 81.0% 82% $56.48 +1% $98,722 Can anyone offer a solution? -- Thank you. A Canes Fan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with a conditional format in regards to "date" input | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
"Daisy-Chain" a conditional format? | Excel Discussion (Misc queries) | |||
Conditional Format Formula "includes" | Excel Discussion (Misc queries) | |||
Cond Format & helper-cell based "duplicate rec" tricked by content | Excel Discussion (Misc queries) |