Highlight rows with certain condition in some cells

[SteveK]

I want to highlight every row that has a certain word in one column and a
different word in another column of the same row. How do I do this?

SteveK

 

[davesexcel]

Here's a great site to learn about conditional formatting


http://www.mvps.org/dmcritchie/excel/condfmt.htm

 

[Max]

I want to highlight every row that has a certain word in one column
and a different word in another column of the same row.
How do I do this?

One interp and play,
assuming the reference col of words is in col A ..

Select A1, press CTRL+A
(this selects the entire sheet with A1 active)

Click Format > Conditional Formatting
Under Condition 1, make the settings as:
Formula is:
=AND(COUNTIF(1:1,$A1)<2,$A1<>"")
Click Format button > Patterns tab > Green? > OK
Click OK at the main dialog

The above will highlight/fill entire rows green
where the reference words in col A are unique "row-wise"
i.e. across the row

---