Forum Discussion
Lowest Unique Value Just Looking At Every Other Cell in a Column
You could create the formulas that I suggested in my first reply. Let's say the formula that returns the unique lowest value is in F2.
Select A2:A100 (the column with the data from my previous example).
A2 should be the active cell in the selection.
On the Home tab, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND(ISEVEN(ROW(A2)),A2=$F$2)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
You could create the formulas that I suggested in my first reply. Let's say the formula that returns the unique lowest value is in F2.
Select A2:A100 (the column with the data from my previous example).
A2 should be the active cell in the selection.
On the Home tab, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND(ISEVEN(ROW(A2)),A2=$F$2)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
- Hans, Perfect! Now for the big question. Can you just write ONE formula for conditional formatting that does all at one time?
Thanks,
MarkI wish! But I couldn't manage to find one... 😞