Conditional Formatting
 

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.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=483695

Conditional Formatting
 

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

Hope this helps
Rowan

ForSale wrote:
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.

Conditional Formatting
 

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

Regards
Rowan

ForSale wrote:
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.

Conditional Formatting
 

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.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=483695

Conditional Formatting
 

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.

Conditional Formatting
 

Thanks. Keep up the good work.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=483695

Conditional Formatting
 

You're welcome.

ForSale wrote:
Thanks. Keep up the good work.