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) |