Forum home » Delegate support and help forum » Microsoft Excel Training and help » Highlight a lowest cell in the row
|
|
|
The UK's most regular 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. |
Highlight a lowest cell in the row
Resolved · Urgent Priority · Version 2007
Reply 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
For upcoming training course dates see: Pricing & availability
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
Reply Mon 21 Nov 2011, 11:52Delegate Konrad said...
RE: highlight a lowest cell in the row
Hi Anthony, thanks for your reply. It works perfectly.
Thanks for your help.
|