d=data.frame(V1=c("xxx","yyy","zzz"), V2=c(NA,"ewruinwe",NA))
d
##    V1       V2
## 1 xxx     <NA>
## 2 yyy ewruinwe
## 3 zzz     <NA>
apply(d, c(1,2), function(x) grepl("ruin", x))
##         V1    V2
## [1,] FALSE FALSE
## [2,] FALSE  TRUE
## [3,] FALSE FALSE
any(apply(d, 2, function(x) grepl("ruin", x)))
## [1] TRUE
#ref https://stackoverflow.com/questions/8999653/grep-on-any-cell-in-a-data-frame