2 conditions for condition formatting

  • Thread starter Thread starter PatLee
  • Start date Start date
P

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.
 
Hi

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



--

Regards
Roger Govier

PatLee said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
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 -
Click to expand...

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

Pat.
 
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
 
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 -
Click to expand...

Pete,
it works, thanks.

Pat.
 
Back
Top