Can conditional formatting used to highlight cells that are changed in the last 15 days?
I know we can use track changes, but I am looking to highlight cells that are changed in the last 15 days all the time.
Appreciate your help!
Thanks,
Pavan.
Can conditional formatting used to highlight cells that are changed in the last 15 days?
I know we can use track changes, but I am looking to highlight cells that are changed in the last 15 days all the time.
Appreciate your help!
Thanks,
Pavan.
If you have a date that goes along with the change, then we can use that with todays date in CF. However, if it is just some cell that was changed, then, apart from VBA, we have no way to know when the change was made
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for you reply. Can the VBA code highlight the cells for certain period of time? If so, could you please help with VBA code? Apprecite your help!
My VBA sucks, but I will move this to the VBA forum for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks