Excel Conditional Formatting

[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

 

[Frank Kabel]

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)

 

[hcj]

in conditional formatting dialog, set cell value is "equal
to", then
=MIN(your cell range), then
select the format you want to use

 

[uplink600]

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

 

[hcj]

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