 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / April 2008Conditional Formatting Question
I have created a pricing matrix in Excel 2003 and I am trying to use the conditional formatting function to highlight the top 3 cheapest prices in each row. I have tried to set up the formatting, but I continue to get an error message that says "Change the reference to a single cell, or use the reference with a worksheet function." I'm a bit of a novice when it comes to this program so any ideas would be appreciated. Thanks, >highlight the top 3 cheapest prices In other words, you want to highlight the 3 *lowest* prices? Ok, will there *always* be at least 3 prices? Where are these prices?  SignatureBiff Microsoft Excel MVP >I have created a pricing matrix in Excel 2003 and I am trying to use the > conditional formatting function to highlight the top 3 cheapest prices in [quoted text clipped - 6 lines] > > Thanks, Yes, I want to highlight the 3 "lowest" prices, which will change daily. I have them linked to another page which will be updated everyday. > >highlight the top 3 cheapest prices > [quoted text clipped - 14 lines] > > > > Thanks, Assuming there will *always* be at least 3 prices... The prices are in the range A1:E1... Select the range A1:E1 Goto the menu Format>Conditional Formatting Formula Is: =AND(A1<>"",A1<=SMALL($A1:$E1,3)) Click the Format button Select the desired style(s) OK out SignatureBiff Microsoft Excel MVP > Yes, I want to highlight the 3 "lowest" prices, which will change daily. I > have them linked to another page which will be updated everyday. [quoted text clipped - 21 lines] >> > >> > Thanks, When I enter in the formula - no change occurs..... Some rows maybe 20 prices, and some may have 10. What I ultimatley am looking to do, is rank the top 3 prices from cheapest, to 2nd cheapest, to 3rd cheapest and have each price highlighted a different color. Sorry if this is confusing.... :) I appreciate your help! > Assuming there will *always* be at least 3 prices... > [quoted text clipped - 35 lines] > >> > > >> > Thanks, Ok... Let's assume the range of interest is A1:G5. Not all rows will have the same amount of numbers in them but the last column that might have a number is column G. Select the range A1:G5 Goto the menu format>Conditional Formatting Condition 1 Formula Is: =AND(A1<>"",A1=MIN($A1:$G1)) Click the Format button Select the desired style(s) OK Click the Add button Condition 2 Formula Is: =A1=SMALL($A1:$G1,2) Click the Format button Select the desired style(s) OK Click the Add button Condition 3 Formula Is: =A1=SMALL($A1:$G1,3) Click the Format button Select the desired style(s) OK out SignatureBiff Microsoft Excel MVP > When I enter in the formula - no change occurs..... > [quoted text clipped - 50 lines] >> >> > >> >> > Thanks, It worked!!! Thank you SO much for your help!! Lindsay > Ok... > [quoted text clipped - 90 lines] > >> >> > > >> >> > Thanks, You're welocme. Thanks for the feedback! SignatureBiff Microsoft Excel MVP > It worked!!! Thank you SO much for your help!! > [quoted text clipped - 99 lines] >> >> >> > >> >> >> > Thanks, |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.