stephenclarke111111111
New Member
- Joined
- Dec 8, 2017
- Messages
- 16
Hi,
I'm after some help please.
I have 4 columns with amounts and #N/A in them and a column next to in showing the Min. I want to highlight the Min amount from those 4 columns.
Column K to N is where I want to highlight the Min --- column O is the Min
=K2:N2=MIN(IF(ISERROR($K$2:$N$2),0,$K$2:$N$2))
This formula isn't highlighting all the rows ?
I'm after some help please.
I have 4 columns with amounts and #N/A in them and a column next to in showing the Min. I want to highlight the Min amount from those 4 columns.
Column K to N is where I want to highlight the Min --- column O is the Min
=K2:N2=MIN(IF(ISERROR($K$2:$N$2),0,$K$2:$N$2))
This formula isn't highlighting all the rows ?