Conditional format formula
 

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

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

Conditional format formula
 

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
-----Original Message-----
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



.

Conditional format formula
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Juan" schrieb im Newsbeitrag
...
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
-----Original Message-----
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



.

Conditional format formula
 

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
-----Original Message-----
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

--
Regards
Frank Kabel
Frankfurt, Germany

"Juan" schrieb im Newsbeitrag
...
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
-----Original Message-----
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



.


.