Conditional Formatting

  • Thread starter Thread starter ForSale
  • Start date Start date
F

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.
 
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
 
Revised formula for the conditional formatting:
=AND(MOD(COLUMN(),2)=0,C1="y",D1="n")

Regards
Rowan
 
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
 
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
 
Back
Top