Forum Discussion
Solved
Help with VLOOkUP MIN Conditional Formatting
30 rows of data. Column A = Names Column B = Yes, No, or N/A Column C = Number (Accounting format). What I'm trying to Achieve: If Column B = Yes OR N/A; then in Column C, identify the Lowest Number...
=SMALL(IF((($B$2:$B$22="yes")+($B$2:$B$22="N/A"))*($C$2:$C$22<>0),$C$2:$C$22),1)=C2With e.g. Excel 2013 you can try this rule for conditional formatting.
=SMALL(IF((($B$2:$B$22="yes")+($B$2:$B$22="N/A"))*($C$2:$C$22<>0),$C$2:$C$22),1)=C2With e.g. Excel 2013 you can try this rule for conditional formatting.
- Thank you! this worked perfectly!
