Hi - I have written in some conditional formatting to have a cells automatically updated based on a response in a cell above. That is: If a no response is chosen to a certain question, then all other questions in that range are to also be a No response.
I have attached the document im working on with an outline of what the problem is!!!!
Any help will be muchly appreciated!!!!
Last edited by fmluder93; 04-26-2009 at 06:19 PM.
=IF(E16="No",+$E$17+$E$17:$E$24+"No")
whats this mean?
"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
This means: If cell E16 is equal to No then i want e17, e18, e19 etc to also equal no. I have tried conditional formatting a few ways - but just dont get it!!!
nope thats not it
you need just
=$E$16="no"
then copy that format to the other cells
Thank you thank you thank you!!!! It was so simple - but of course i had to complicate it!!! Your help is GREATLY appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks