Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
In Excel 2007, I have a worksheet with dollar amounts in columns M, N, and R.
These values start in row 5 and go down to 12,456. I need to pick out the lowest value in each row and give it a color (green for example). Some of the cells in these ranges are blank, and those cells with a null value should not be considered the lowest amount. I have been stumbling around attempting to use conditional formatting, to no avail. Please help so I do not need to do this manually. Many, many thanks Marsh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting comparing two columns | Excel Worksheet Functions | |||
Conditional Formatting - Comparing 2 columns | Excel Worksheet Functions | |||
Conditional Formating comparing the two columns | Excel Discussion (Misc queries) | |||
Conditional Formatting-Comparing Two Columns | Excel Discussion (Misc queries) | |||
Conditional Formatting-Comparing Two Columns | Excel Discussion (Misc queries) |