Forum Discussion
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. Wher...
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.