Highlight automatically a specific cell
 

i am working on a spreadsheet and need some help, it's hard to explain what i
want but i'll try my best, here goes! I have a sheet and on it i have several
amounts in different cells like this:-

20.36 19.36 17.24 17.54 19.81 20.12

I want the cell with the lowest amount in it to show in a different colour
font automatically, so 17.24 in the third column would show in red and the
rest in black, then if i changed the amount in the first column to 16.99 it
would automatically change to red and the amount in the third column would go
back to black as it would no longer be the lowest amount. is there a way this
can be done.

Highlight automatically a specific cell
 

formatconditional formattingformula is=a2=min($a$2:$g$2)format as
desired


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Frances Holden" wrote in message
...
i am working on a spreadsheet and need some help, it's hard to explain what
i
want but i'll try my best, here goes! I have a sheet and on it i have
several
amounts in different cells like this:-

20.36 19.36 17.24 17.54 19.81 20.12

I want the cell with the lowest amount in it to show in a different colour
font automatically, so 17.24 in the third column would show in red and the
rest in black, then if i changed the amount in the first column to 16.99
it
would automatically change to red and the amount in the third column would
go
back to black as it would no longer be the lowest amount. is there a way
this
can be done.