software

Is there a quot;andquot; function available in Excel? I want to check the contents
of two different cells and if both are true change the format of another
cell. For example:
if quot;a2=ASTquot; and if a3=quot;Yquot; If both are true set the conditional format. Thanks


Hi AJK,

Yes there is, one solution you can use for your conditional formatting
is:

=if(and(a2=quot;ASTquot;,a3=quot;Yquot;),quot;truequot;,quot;falsequot;)

btw, your first port of call when you have a question should be the
help files ie [F1]. Type in quot;and functionquot; and have a read.

hth
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=537169Yes: as it is a function the format is AND(condition1,condition2 etc).
So in your case the formula would be:

AND(A2=quot;ASTquot;,A3=quot;Yquot;)

then set your format for the cell.

Hope this helps.

PeteThanks to both of you for the help. I had looked in a book and did not find
the quot;andquot; function. I then went to help and found it.

Thanks again.

quot;Pete_UKquot; wrote:

gt; Yes: as it is a function the format is AND(condition1,condition2 etc).
gt; So in your case the formula would be:
gt;
gt; AND(A2=quot;ASTquot;,A3=quot;Yquot;)
gt;
gt; then set your format for the cell.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;


Hi,
no problem, pleased I could help amp; thanks for the feedback.

as you may have noticed, the if part of my formula is redundant, only
the quot;andquot; is needed as shown by Pete.

Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=537169Thanks for feeding back, both of you.

Pete