Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Mouimet -
I would record a macro while adding the conditional formatting to the columns. Then you can add code to run that macro after the user updates any of the date fields in column P (or column A if they are allowed to change that one). -- Daryl S "Mouimet" wrote: 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Are the start and close dates in the same row in A and P?
If so, what's the problem? If the row is deleted, the formatted date in P is gone along with the start date in A Please use some cell references for your dates locations. Gord Dibben MS Excel MVP On Thu, 28 Jan 2010 07:13:01 -0800, Mouimet wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |