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.
