Conditional Formating

[peterh]

I am not having any success at this, I have 5 cells with figures:-
G5=1
J5=14
M5=0
P5=15
S5=2
I want to highlight in a colour & bold the lowest figure, not oncluding anym
zeros,
I am trying =$G6=MIN(IF(OR(G6,J6,M6,P6,S6)>0,OR(G6,J6,M6,P6,S6)))
Need help, Please.

 

[barry houdini]

Hello peter,

Try this formula within conditional formatting for G5 then copy to the
other cells

=G5=MIN(IF(MOD(COLUMN($G5:$S5)-COLUMN($G5),3)=0,IF($G5:$S5>0,$G5:$S5)))