Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
1. Select the cell/Range.Column A.
2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =COUNTIF(B1:R1,MAX(B:R)) 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK PS: IF the initial selection is not entire column A and say A2:A10; then the formula would be =COUNTIF(B2:R2,MAX($B$2:$R$10)) If this post helps click Yes --------------- Jacob Skaria "Steve" wrote: If I have a list oif names in the A column, and various #s in columns B thru R, and the max of those #'s is in B20. Can I conditional format any A column name that has the max # (14) in it's row. Basically I'd like to conditional format the names Steve and Billy because they're the only ones that have a 14 in their row. Thanks, A B ..... Q R Steve 13 14 11 Rick 13 7 10 Billy 12 14 9 Kurt 13 7 9 Dan 12 6 13 max 14 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Based on Colors in a Horz Range of Cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
How to conditional format columns in a range based on | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional formatting based on date range | Excel Discussion (Misc queries) |