formula for auto colouring cell if containing certain word?

[dbwoods11]

Is it possible to have a cell auto-colour itself if a certain word is present?

Ex:
If any B cell="sell", colour cell red, no colour

My thought:
=IF(B:B="sell",colour red, no colour)

Obviously that would not work so I'm wondering if its even possible.
Has anyone heard of this before?

Thanks.

[vlady]

you are referring to conditional formatting...

Use Format|Conditional Formatting
Set the first box to "Cell value is equal to" follow steps.

[dbwoods11]

Ok that worked. Now to expand on that.

If a word in cell A1="sell", colour (A1,C1,D1) red, no colour
So this is building a formula in the conditional formatting right?

My best guess: Highlight column A,C,D
=(A:A="sell")

I would like this to work all the way down.

[vlady]

yup highlight A,C,D then formula

=$A1="sell"

if you you prefer that the word sell will be either the 3 columns A,C,D
you can use the or

=OR($A1="sell",$C1="sell",$D1="sell") -> so if the word sell is in C or D it will still highlight the rows A,C,D