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