Simpler rules
#1: =COUNTIF(A2:C2,"yes")=3
#2: =COUNTIF(A2:C2,"yes")>0
#3: =COUNTIF(A2:C2,"yes")=0
If using Excel 2007, ensure that you tick the STop If True box, otherwise #'2 can override #1.
Simpler rules
#1: =COUNTIF(A2:C2,"yes")=3
#2: =COUNTIF(A2:C2,"yes")>0
#3: =COUNTIF(A2:C2,"yes")=0
If using Excel 2007, ensure that you tick the STop If True box, otherwise #'2 can override #1.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote