View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PeterH PeterH is offline
external usenet poster
 
Posts: 20
Default Conditional Formating

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.