2 conditions for condition formatting

[PatLee]

dear all,
in below table, I need to set the CF in column A when column A and B
both are equal to Y. In CF rule, I set below, but A4 doesn't show the
highlight color. Please help.

="and($A$1:$A$4=Y,$B$1:$B$4=Y)"

colA colB
Y N
N N
N Y
Y Y

Thanks in advance
Pat.

 

[Roger Govier]

Hi

Change to
=and($A$1:$A$4="Y",$B$1:$B$4="Y")



--

Regards
Roger Govier

dear all,
in below table, I need to set the CF in column A when column A and B
both are equal to Y. In CF rule, I set below, but A4 doesn't show the
highlight color. Please help.

="and($A$1:$A$4=Y,$B$1:$B$4=Y)"

colA colB
Y N
N N
N Y
Y Y

Thanks in advance
Pat.

__________ Information from ESET Smart Security, version of virus
signature database 5165 (20100602) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5165 (20100602) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[PatLee]

Hi

Change to
=and($A$1:$A$4="Y",$B$1:$B$4="Y")

--

Regards
Roger Govier












__________ Information from ESET Smart Security, version of virus signature database 5165 (20100602) __________

The message was checked by ESET Smart Security.

http://www.eset.com- Hide quoted text -

- Show quoted text -

Roger,
thanks for your help.
after using your formula, it still doesn't get the result, i.e. A4 is
highlighted.

Pat.

 

[Pete_UK]

Highlight A1:A4 with A1 as the active cell, then click on Conditional
Formatting and use this formula:

=AND(A1="Y",B1="Y")

Set your formatting and exit the dialogue box - Excel will
automatically adjust the cell references to suit the other rows.

Hope this helps.

Pete

 

[PatLee]

Highlight A1:A4 with A1 as the active cell, then click on Conditional
Formatting and use this formula:

=AND(A1="Y",B1="Y")

Set your formatting and exit the dialogue box - Excel will
automatically adjust the cell references to suit the other rows.

Hope this helps.

Pete




- Show quoted text -

Pete,
it works, thanks.

Pat.

 

[Pete_UK]

You're welcome, Pat - thanks for feeding back.

Pete