If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I show the low-price supplier from seven different quotes?
|
#2
|
|||
|
|||
How do I show the low-price supplier from seven different quotes?
Since you don't give any detail, I'll assume that your quotes are in
B2:H2 and that you want to show the low-price supplier via conditional formatting. Select B2:H2, with B2 the active cell. Choose Format/Conditional Formatting and set the dropdowns and textboxes to CF1: Formula is =B2=MIN(B2:H2) Click Format: Format1: Patterns/color of your choice In article , !Maniac McGhee! !Maniac wrote: |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help creating an Excel formla to calculate price before sales tax | [email protected] | General Discussion | 3 | December 10th, 2005 01:00 AM |
Automatic exit of PowerPoint slideshow | cfryar | Powerpoint | 1 | October 1st, 2005 09:55 PM |
Value between 2 dates | AG | Worksheet Functions | 11 | August 21st, 2005 05:32 PM |
How on my webpage can go straight to Slide Show View | Peter Dunne B.Sc. | Powerpoint | 2 | March 21st, 2005 05:13 PM |
Power Show Problems | Fran McConville | Powerpoint | 3 | October 18th, 2004 02:52 AM |