It sounds like D1 was not the activecell when you entered the
conditional formatting. Select a single cell eg D3 and go into
conditional formating. If you are in D3 the formula should read:
=AND(MOD(COLUMN(),2)=0,C3="y",D3="n")
My guess is yours reads:
=AND(MOD(COLUMN(),2)=0,C2="y",D2="n")

To correct this select columns D to AA again (includig Row1) and make
sure that D1 is the activecell. FomatConditional
FormattingDeleteCondition1Ok.
Then reapply the conditional formatting using the formula:
=AND(MOD(COLUMN(),2)=0,C1="y",D1="n")

Hope this helps
Rowan


ForSale wrote:
Thanks,
This is close, but it is highlighting a row down. When I put "y" in c3
and "n" in d3, d4 turns red. I'm sure there is a simple modification to
that formula, but I'm no good with formulas. Thanks again.