Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight lowest price in a row.
I have multiples cells with the lowest prices from different vendors. I need
to automatically highlight the lowest price in each row of cells without sorting the data. I would like the numbers to be Bold Red and the Background to be Yellow. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight lowest price in a row.
formatconditional formattingformula is =j2=max(J:J)format as desired
-- Don Guillett Microsoft MVP Excel SalesAid Software "chadboehne" wrote in message ... I have multiples cells with the lowest prices from different vendors. I need to automatically highlight the lowest price in each row of cells without sorting the data. I would like the numbers to be Bold Red and the Background to be Yellow. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight lowest price in a row.
Use conditional formating with "formula equals"
Use the following formula in cell A1. Min(1:1) is the entire row 1. =IF(A1=MIN(1:1),TRUE,FALSE) Then select the Font to be Red and the Pattern to be yellow. To copy conditional formating to other cells do the following: Copy cell A1 and use Paste Special - Formats to copy this formula to other cells. "chadboehne" wrote: I have multiples cells with the lowest prices from different vendors. I need to automatically highlight the lowest price in each row of cells without sorting the data. I would like the numbers to be Bold Red and the Background to be Yellow. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight lowest price in a row.
There is no need for the TRUE/FALSE action as
=A1=MIN(1:1) will return TRUE or FALSE quite happily You might also want to cater for blanks =AND(A1<"",A1=MIN(1:1)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Joel" wrote in message ... Use conditional formating with "formula equals" Use the following formula in cell A1. Min(1:1) is the entire row 1. =IF(A1=MIN(1:1),TRUE,FALSE) Then select the Font to be Red and the Pattern to be yellow. To copy conditional formating to other cells do the following: Copy cell A1 and use Paste Special - Formats to copy this formula to other cells. "chadboehne" wrote: I have multiples cells with the lowest prices from different vendors. I need to automatically highlight the lowest price in each row of cells without sorting the data. I would like the numbers to be Bold Red and the Background to be Yellow. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight lowest price in a row.
Don: Why did you use Max instead of Min?
"Don Guillett" wrote: formatconditional formattingformula is =j2=max(J:J)format as desired -- Don Guillett Microsoft MVP Excel SalesAid Software "chadboehne" wrote in message ... I have multiples cells with the lowest prices from different vendors. I need to automatically highlight the lowest price in each row of cells without sorting the data. I would like the numbers to be Bold Red and the Background to be Yellow. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight lowest price in a row.
Thank you!!! I am the coolest guy in the office now...You guys are the best!
"Bob Phillips" wrote: There is no need for the TRUE/FALSE action as =A1=MIN(1:1) will return TRUE or FALSE quite happily You might also want to cater for blanks =AND(A1<"",A1=MIN(1:1)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Joel" wrote in message ... Use conditional formating with "formula equals" Use the following formula in cell A1. Min(1:1) is the entire row 1. =IF(A1=MIN(1:1),TRUE,FALSE) Then select the Font to be Red and the Pattern to be yellow. To copy conditional formating to other cells do the following: Copy cell A1 and use Paste Special - Formats to copy this formula to other cells. "chadboehne" wrote: I have multiples cells with the lowest prices from different vendors. I need to automatically highlight the lowest price in each row of cells without sorting the data. I would like the numbers to be Bold Red and the Background to be Yellow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation based on lowest price | Excel Discussion (Misc queries) | |||
highlight lowest value in a list | Excel Discussion (Misc queries) | |||
CF to highlight lowest price in row | Excel Worksheet Functions | |||
Highlight lowest number | Excel Discussion (Misc queries) | |||
How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions |