Conditional Formatting

[ForSale]

Every column between C and AA will have either "y" or "n" in it. One
the odd columns starting with C, I need no conditional formatting. In
the even columns starting with D, I need a conditional format that will
turn the cell red if the cell to the left is "y" and this one is "n".
For example:
C D E F
y y n n
y n y y
n n y n

I need to be alerted to D3 and F4.

Thanks.

 

[Rowan Drummond]

Select columns D to AA so that D1 is the activecell (white and D1
appears in the formula bar).
Format>Conditional Formatting. Formula is:
=IF(AND(MOD(COLUMN(),2)=0,C1="y",D1="n"),TRUE,FALSE)
Set the formatting required.

Hope this helps
Rowan

 

[Rowan Drummond]

Revised formula for the conditional formatting:
=AND(MOD(COLUMN(),2)=0,C1="y",D1="n")

Regards
Rowan

 

[ForSale]

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

 

[Rowan Drummond]

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. Fomat>Conditional
Formatting>Delete>Condition1>Ok.
Then reapply the conditional formatting using the formula:
=AND(MOD(COLUMN(),2)=0,C1="y",D1="n")

Hope this helps
Rowan

 

[ForSale]

Thanks. Keep up the good work.

 

[Rowan Drummond]

You're welcome.