98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Highlight a lowest cell in the row
Highlight a lowest cell in the row
Resolved · Urgent Priority · Version 2007
Mon 21 Nov 2011, 10:23Delegate Konrad said...
Konrad has attended:
Excel Introduction course
Highlight a lowest cell in the row
Hi,
How can i highlight the lowsest price/cell in the row but for entire spread sheet? I don't want to do this one row at the time as it takes ages but if i highlight more than one row it will give me the lowest price in all those rows.
Many thanks,
Konrad
Mon 21 Nov 2011, 11:02Trainer Anthony said...
RE: highlight a lowest cell in the row
Hi Konrad, thanks for your query. Select all your numbers (my range will be from B1 down to D4)
Go to Home - Conditional Formatting - New Rule
Use a formula to determine which cells to format
=B1=MIN($B1:$D1)
Build the highlight format you need then apply it.
Note there is a bug in the software and you may need to go back into the rule (via Conditional Formatting, Manage Rules, Edit Rule) to reapply the formula - Excel changes the parameters behind your back!
Hope this helps,
Anthony
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Toggle Formulas and ResultsCtrl + 'The key above Tab with the |
