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
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
