Conditional Formatting (Custom)

[jjramirez85]

I have three cells that calculate variances, so I want to highlight negative variances. I dont want to highlight "all" negative variances thought, but instead I want to highlight the largest variances of 3 different cells.

My first attempt was selecting all cells and choosing the bottom 1 option, but I noticed when the outputs are above zero that it will still highlight the bottom one, so I want to add in the negative piece.

 

[Scott T]

If your numbers are in A2:A4 then you can select the cells and use this formula.

=IF(MIN($A$2:$A$4)<0,MIN($A$2:$A$4),FALSE)=A2

IF there is a tie for lowest number this will highlight both of them

 

[Joyner]

If numbers A1 to C1 and down: =AND(A1<0,A1=MIN($A1:$C1))