COLOUR CHANGE IS A CELL

[Mav]

Cyber taz
What I am trying to do is use say a red coulured cell but when text is added
to the cell it changes colour to green.
The other thing if possible a drop down menu in a cell so when clicked on it
offers three of four selection
For example
today
tomorow
yesterday
day after
And once one wes highlighted it would show in the cell.
Thankls for your help it is really apprereciated.

[Debra Dalgleish]

You can use data validation to create a dropdown list in a cell. There
are instructions in Excel's help, and here:

http://www.contextures.com/xlDataVal01.html

Mav wrote:
> Cyber taz
> What I am trying to do is use say a red coulured cell but when text is added
> to the cell it changes colour to green.
> The other thing if possible a drop down menu in a cell so when clicked on it
> offers three of four selection
> For example
> today
> tomorow
> yesterday
> day after
> And once one wes highlighted it would show in the cell.
> Thankls for your help it is really apprereciated.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[LarryUK]

Mav

Send e-mail to [email protected] and i will send you sample excel file

Larry