Conditional format formula
Hi
try the formula
=ISERROR(SEARCH("Americas",A1))
--
Regards
Frank Kabel
Frankfurt, Germany
"Juan" schrieb im Newsbeitrag
...
Hello All,
Kind of stuck. Looking for a formula in conditional format
to color rows where entries does not contain the starting
word is Americas. I tried to do less than Americas, which
it colors the rows but it seems to color the Whole Column.
I don't want whole column just those rows.
any help would be very appreciated.
Thanks,
Juan
|