| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight Largest Amount in a row
I want to the largest amount listed in a row range to be highlited and
bolded. I set up the conditional format formula below, but it highlights and bold any cell that has a number in it. =MAX(P18:P41) What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight Largest Amount in a row
highlight P18:P41
set formula is =P18=max(P$18:P$41) "Supe" wrote: I want to the largest amount listed in a row range to be highlited and bolded. I set up the conditional format formula below, but it highlights and bold any cell that has a number in it. =MAX(P18:P41) What am I doing wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlight Largest Amount in a row
Thanks
"bj" wrote: highlight P18:P41 set formula is =P18=max(P$18:P$41) "Supe" wrote: I want to the largest amount listed in a row range to be highlited and bolded. I set up the conditional format formula below, but it highlights and bold any cell that has a number in it. =MAX(P18:P41) What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert the amount in currency into the amount in words? | Excel Discussion (Misc queries) | |||
| highlight largest number in a row | Excel Worksheet Functions | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| format row of cells to highlight least amount | Excel Worksheet Functions | |||
Linear Mode
