Cell A1: International Studies Academy (P) 9-12
Cell A2: Public
Is there a way that I can get Cell A2 to fill red when cell A2="Public" and A1 contains "(P)"?
I can't seem to get a formula to work yet.
Thanks!
Cell A1: International Studies Academy (P) 9-12
Cell A2: Public
Is there a way that I can get Cell A2 to fill red when cell A2="Public" and A1 contains "(P)"?
I can't seem to get a formula to work yet.
Thanks!
Last edited by PowerSchoolDude; 07-01-2009 at 06:54 PM.
cf formula is
=AND(ISNUMBER(SEARCH("(p)",A1)),A2="public")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Awesome! You rock.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks