View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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