Excel Conditional Formatting

  • Thread starter Thread starter uplink600
  • Start date Start date
U

uplink600

Good Afternoon

Could someone please advise how I can use conditional formatting or
function/formula to change the colour of a cell that contains th
lowest value in a particular range.

ie

25.66
34.99
16.99 <--------change colour of text and/or fill
17.99
45.99

Thanks

V
 
Hi
if your values are in A1:A10 try the following:
- select A1:A10
- goto 'Format - Conditional Format'
- enter the following formula
=A1=MIN($A$1:$A$10)
 
in conditional formatting dialog, set cell value is "equal
to", then
=MIN(your cell range), then
select the format you want to use
 
Thanks

That works OK.

I do have a worksheet with data across approx 50 rows and
need this to work in the range D4:G125.

How do I copy the conditional formula to all rows.

Thanks once again.

V
 
Glad it helped. Forgot to mention that you can select the
range directly from the sheet. Excel will enter the range
coordinates for you when you select. Note it uses
absolute references ($col$row:$col$row). If you type the
range, be sure to include $ refs. Selection can be any
size - multiple cols and rows - AND can be discontinuous.
For this say =MIN($col$row:$col$row,$col$row:$col$row,
etc.). Very powerful.
Good luck
 
Back
Top