| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA Show in red if Date another date
Hi,
Small Problem I think Because the user can delete Rows in the worksheet I can not use the normal Conditional formating. I think the VBA is the solution Col "A" have a date, example: 2009-01-25 The user will add a date in Col "P" to close the lead. Example: 2009-03-02 I need to highlight the date in Column "P" if it is 45 days over the date in Col "A". The only way I can see is using the VBA. Like I said, I need to select the col ("A:A") and ("P:P") because the user can sometimes delete some rows. Can someone help me on this? THanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To show month end date from any date entered | Excel Discussion (Misc queries) | |||
| show the date when it is later than today's date | Excel Worksheet Functions | |||
| Show a date based on another date | Excel Discussion (Misc queries) | |||
| How to show date in H2 based on date in I2 minus set number of day | Excel Discussion (Misc queries) | |||
| Date subtraction -How to not show negative when 2nd date not entered | New Users to Excel | |||
Threaded Mode
