| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Apply green to current date, red to 2 days overdue and none if pai
Hi,
I'd like to find out how to format an Excel 2002 worksheet to highlight the current date (in column A) in green and then if it is overdue by more than 2 days to change to red but if the amount has been paid in full (shown in column F) to revert back to white, please. Many thanks, vpschas (UK) |
Threaded Mode
