Formatting Rows based on word being found in cell

[amorrison2006]

I have multiple static words which I want to have a macro search for
within the first two columns of the sheet.

If the words are found then the rows are to be formatted in bold.

I tried to record a macro for this but was hopeless.

Can someone help?

There are around 5 words in totals that I would like the macro to
search for.

Thank you

Andrea

 

[Ken]

Andrea

If the words you are looking for constitute the entire contents of the
cells in columns A or B, you can accomplish this easily with
conditional formatting.

The condition would be something like:

Condition 1
Formula is =or($a1="one", $a1="two", $b1="one",$b1="two")

but including all 10 possibilites in the OR statement, assuming each of
the 5 words could be in either column A or B. If some words can be in
only one of the columns you would of course have fewer possibilites in
your OR statement.

If the words can be embedded in longer strings in those columns, you
have a more difficult, but not insurmountable, situation.

Good luck.

Ken
Norfolk, Va

 

[Don Guillett]

You say first two columns. Do you mean word in EITHER column of the row or?

 

[Don Guillett]

Or, (NO pun intended)

=OR(a1={"a","b"})
=OR(C1={"a","b"},C2={"x","y"})