| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlight largest number in a row
I am working on a spreadsheet and want the highest number in a row to be
highlighted. Can someone tell me how to format this to work automatically. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlight largest number in a row
snmcpa wrote: I am working on a spreadsheet and want the highest number in a row to be highlighted. Can someone tell me how to format this to work automatically. In a cell on your sheet lets say C1 enter =LARGE(A2:A7,1) which looks for the largest number in the range. This assumes the range to look for the largest value is A2:A7. Now use conditional formatting in the range A2:A7, if the value in the range is equal to the result in C1, format to your liking with borders, background colors, etc. Pierre |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
highlight largest number in a row
Thanks.
"Pierre" wrote: snmcpa wrote: I am working on a spreadsheet and want the highest number in a row to be highlighted. Can someone tell me how to format this to work automatically. In a cell on your sheet lets say C1 enter =LARGE(A2:A7,1) which looks for the largest number in the range. This assumes the range to look for the largest value is A2:A7. Now use conditional formatting in the range A2:A7, if the value in the range is equal to the result in C1, format to your liking with borders, background colors, etc. Pierre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| find the largest number in column | Excel Discussion (Misc queries) | |||
| cell's address of the largest number | Excel Discussion (Misc queries) | |||
| Highlight lowest number | Excel Discussion (Misc queries) | |||
| Ranking cells largest to smallest | Excel Discussion (Misc queries) | |||
Linear Mode
