MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula or format?


Posted by Dennis Merritt on October 17, 2001 11:05 AM

I have a cell that must meet 3 criteria in order to hightlight. I have impimented to first two using a conditional format, problem is the 3rd criteria is a text string and Im not sure how to do that. Any ideas?

Thanks


Posted by Mark W. on October 17, 2001 11:07 AM

Please describe your 3rd criteria (nt)

Posted by Aladin Akyurek on October 17, 2001 11:08 AM

Dennis,

What are those criteria?

Aladin

Posted by Dennis Merritt on October 17, 2001 11:17 AM

My first is if cell "a" is > 40 - no problem here.
The second is if cell "b" is > 1 - got that covered.
Problem is that for my third criteria to be met the text "xx" or "yy" must be typed into the 3rd cell. Thats where I run into problems.

Posted by Mark W. on October 17, 2001 11:20 AM

Use =OR(C2="xx",C2="yy") (nt)

Posted by Aladin Akyurek on October 17, 2001 11:24 AM

Dennis,

You are probably looking for:

=OR(C1="xx",C1="yy")

A given cell cannot meet all of these 3 criteria, so I'm not sure about what you're trying to do.

Aladin

Posted by Dennis Merritt on October 17, 2001 11:31 AM

What I am doing is this. In order for a cell to highlight cell "a" must be > 40, cell "b" must be > 1, and cell "c" must contain the text "xx" or "yy" in order for the 4th cell to hightlight. I hope that this would be possible! Thanks.

Posted by Mark W. on October 17, 2001 11:37 AM

Use a single compound condition... =AND(A2>40,B2>1,OR(C2="xx",C2="yy")) (nt)

Posted by Dennis Merritt on October 17, 2001 11:45 AM

Re: Use a single compound condition... AT LAST!!!!!!!!

Thank you! I have been pulling my hair out trying to figure this one out! Thanks a million!

Posted by Dennis Merritt on October 17, 2001 12:01 PM

Re: Use a single compound condition... =AND(A2>40,B2>1,OR(C2=

Once this cell is highlighted is it possible for it to unhighlight when text is entered?

Posted by Aladin Akyurek on October 17, 2001 12:41 PM

Re: Use a single compound condition... =AND(A2>40,B2>1,OR(C2=

Change the formula to:

=AND(A2>40,B2>1,OR(C2="xx",C2="yy"),NOT(ISTEXT(cell)))

where "cell" is the cell for which this formula will be applied via conditional formatting.

Aladin

Posted by Dennis on October 18, 2001 3:53 AM

Re: Use a single compound condition... =AND(A2>40,B2>1,OR(C2=

Thanks for the help, but it doesnt seem to do anything.