Forum Discussion
Tigger
Dec 19, 2024Copper Contributor
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.