| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I format a cell on a specific date?
I have a spreadsheet that has the following:
Column 1 = Person's name Column 2 = Amount due I need cells to change colour if the amount due is not paid by the 20th of the month. I have managed to figure out the date bit but unsure of what to put for the value as the amount due for each person is different. I hope this makes sense. Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date with specific regional format | Excel Worksheet Functions | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| how can I format a cell to change on a specific date | New Users to Excel | |||
| Forcing a specific date format | New Users to Excel | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Threaded Mode
