View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Marsh Marsh is offline
external usenet poster
 
Posts: 37
Default Comparing three columns, Conditional Formatting

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