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!! |
how to colour a cell green if another cell is filled with text
use Conditional FOrmatting. See:
http://www.contextures.com/xlCondFormat01.html -- Gary''s Student gsnu200710 "terence" wrote: 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!! |
how to colour a cell green if another cell is filled with text
Format/ Conditional formatting/ Formula is: =NOT(ISBLANK(A1)) .
Other options are =ISNUMBER(A1) if the date is entered as a number, or =ISTEXT(A1) if it is text. -- David Biddulph "terence" wrote in message ... 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!! |
how to colour a cell green if another cell is filled with text
Color the cell as orange, so this becomes the 'default' color. Then,
Format-Conditional Formatting. Then specify Condition 1 as Cell Value is not equal to "". Click on Format button and specify the green backgroun. "terence" wrote: 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!! |
All times are GMT +1. The time now is 09:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com