LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting comparing two columns Shelina Excel Worksheet Functions 6 November 5th 09 06:56 PM
Conditional Formatting - Comparing 2 columns LinLin Excel Worksheet Functions 1 April 3rd 09 02:20 AM
Conditional Formating comparing the two columns Harry Excel Discussion (Misc queries) 3 October 30th 08 02:12 AM
Conditional Formatting-Comparing Two Columns Tom K Excel Discussion (Misc queries) 3 May 8th 06 01:03 PM
Conditional Formatting-Comparing Two Columns Tom K Excel Discussion (Misc queries) 1 May 4th 06 06:16 PM


All times are GMT +1. The time now is 03:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"