Using Excel to validate data

[SteveA]

Hi - I'm trying to use excel to validate a column of data for 2 specific values. What I'd like to do is have one formula that looks at the cell range (j15:j503) and tests that range for 2 acceptable values either blank or the text string "xyz123". If all cells conform, display "Good" on the formula cell, if any cells don't conform display "Bad".

 

[Luke M]

=IF(ROWS(J15:J503)=COUNTIF(J15:J503,"xyz123")+COUNTBLANK(J15:J503),"Good","Bad")

 

[SteveA]

thanks Luke M works great!

 

[Luke M]

Great, thanks for the feedback!