Conditional format formula

[Juan]

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

 

[Frank Kabel]

Hi
try the formula
=ISERROR(SEARCH("Americas",A1))

 

[Juan]

Hello Frank,
thanks. But doesn't seem to work. It does colors the cell
but not the complete row, which is what I want to do. Plus
it still colors the Whole Column.
I'll continue playign around with this and see if I'm
able to get it to work.
Any other ideas would be great.

Thanks for your time

Juan

 

[Frank Kabel]

Hi
lets say you want to color row 1 if cell A1 contains this text.
- select the entire row
- goto the conditional formating dialog
- enter the following formula:
=ISERROR(SEARCH("Americas",$A1))

You can even select more rows and enter the same formula or copy this
format to other rows

 

[JUAN]

Hello Frank,
I think my brain is fried or something. I have other
spreadsheet that seem to be fine, but now that I'm doing
different file having problems. I think I need to relax
Thanks alot for your help.

Really aprreciated.

Thanks,

Juan