Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to colour a cell green if another cell is filled with text
Im making a project plan in excel.
Letc say Ive got 10 different cells (10 different tasks) that each of them needs to filled with a date when the individual task has been completed. I have in the end a summary of yet another 10 small cells each corresponding to the other 10 cells (this for a qick overview) So if the first task has been completed the user filles out the date AND then I want the small cell to turn inte the colour GREEN, how can you do this? I would also want that if there is NO text in a cell the small cell should be default orange colour. thanks for any help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell filled with colour canĀ“t be seen, only with print preview | Excel Discussion (Misc queries) | |||
Count filled colour in cell in given range | Excel Discussion (Misc queries) | |||
Text Colour In Linked Cell | Excel Discussion (Misc queries) | |||
get a cell to change colour from a value, eg 1to7=green etc | Excel Discussion (Misc queries) | |||
Can i add up all green filled cells in a workbook? | Excel Worksheet Functions |