How to Compare between cells and choose smallest value
Hi,
Select you 4 cells - in my case A1 - A4 then
Format|Conditional format
Formula is
=A1=MIN($A$1:$A$4)
Pick a colour and click OK
Mike
"Smallest value cell change color" wrote:
If I have four cells, and I want the one with the smallest value change
color automatically.
|