Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COLOUR CHANGE IS A CELL
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. |
#2
|
|||
|
|||
You can use data validation to create a dropdown list in a cell. There
are instructions in Excel's help, and he 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I fill colour in a excel cell from a return from an "IF" test. | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions |