Forum Discussion

Tigger's avatar
Tigger
Copper Contributor
Dec 19, 2024

Conditional Formatting but only if more than 1 value

Hi, 

I want to use conditional formatting to change the font of the lowest number in a range.  This is fine generally however, if there is only 1 value in a range the font of this will change.  Where there is only 1 value I don't want the font colour to change. What formula can I use to change the font colour of the lowest number only if there is only 1 number in a range?

  • Let's say you want to apply this to G2:G25.
    Select this range; G2 should be the active cell in the selection.
    On the Home tab of the ribbon, click Conditional Formatting > New Rule...
    Select 'Use a formula to determine which cells to format'.
    Enter the formula

    =AND(G2=MIN($G$2:$G$25), COUNTIF($G$2:$G$25, G2)=1)

    Click Format...
    Activate the Fill tab.
    Select a fill color.
    Click OK, then click OK again.

Resources