Thanks Guys - it's so simple when you know how. I know the $ makes the
reference absolute, as I intend inserting lines but not columns in the table
(alot of them) would I be right in saying that I would us "B$3 and B$4" in
the formula instead of "$B$3 AND $B$4"?

Tel

"Tel" wrote:

Forgive me if I haven't got the title quite right but this is what I'm trying
to achieve.

I'm trying to set up a conditional format that will change the colour to red
if Cell b3 = Yes and Cell b4 = No then Red
If cell b3 = No and cell b4 = yes then red
but if cell b3 = yes and cell b4 = yes then no change.

I'm not completely au fait with IF statements or if they can be used in CF
but any help would be appreciated.

Thanks

Tel