Can cells change color when others have entries? And other tricks too???
Posted by Bret on March 10, 2001 11:57 PM
Ok, since you guys have helped me so much already,
and yes, I am a rank beginner at this, I wonder if
you can help me out some more.
We are using Excel to display a status board at an Air Traffic
Control center, and are trying to make it both more user
friendly and more versatile. Can anyone tell me a simple way to
make a cell that displays plain text change color when an
adjacent cell has anything typed into it, that is, it is in a non-empty state.
And to add a couple more dreams I have for my form, is there
a way to have a blank (no entry) be a pickable option when
limiting cell entries to a drop-down list? I need to have the words
"open", "closed", and also a blank option all in the same drop-down. Also is
it possible to have the "open" and the "closed" be in different colors in the
And the last, (oh wait, there's another after this, too)
and probably most remote possibilty, is there a way to have a drop-down
list that offers both pre-selected and user enterable values?
I'd like to make a drop down that offers, for example, the common entries
"330/280", and "300/280", and also offers the user an option to enter a custom value.
And the last, really the last one, is we have time values displayed on our status board that
specify a condition that will last for a certain time, for example, certain airspace will
be unavailable to civil traffic from 1930-2130 Zulu. Is there a way that I could program
Excel to clear a cell after a specified time period?
I know I'm probably dreaming, but then I've seen you guys show how to do some amazing things.
So got any tricks up your sleeves on this one?
There's a link to a sample of my form below if you want to have a look; it'll all become clear
what I need if you see it.
Thanks a bunch!