| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I write a formula to color code based on dates provided or.
I am trying to do the following: If a date is in cell A1, B1, C1 and then I
would like to have D1 color codes green, if a date is in A1 and B1 and nothing in C1 I would like cell E1 to be colored yellow and so on. I work for a business and we will be using a date table to show the progress of a project. We are looking for a simple way to show the status of each project by using colors. Red meaning urgent, green OK and yellow some work still needed. Anyone have any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write formula to compare two values and pull the resulta. | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| formula based on format | Excel Discussion (Misc queries) | |||
| How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
Threaded Mode
