SteveK said:
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
