Shade the rows for different working days
Solved/Closed
Related:
- Shade the rows for different working days
- Skype last seen days ago - Guide
- How to calculate 90 days from date in excel - Guide
- Move files older than x days windows - Guide
- Hay day download for pc - Download - Simulation
- Facebook restricted my account for 30 days - Facebook Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 19, 2010 at 04:51 AM
Jul 19, 2010 at 04:51 AM
If all you need to color the row based on the difference between current calendar date and the date in the cell, then you dont need VB. This can be done via Conditional Format.
However if you want to color the row and retain it on ward, then you would need a VB code. By retaining I mean, let say today the conditions are true and the row is blue. Now you save the file and after a month you open it. Now if you still want the book to show the colors as they were when you closed the book, then you would be needing a VB code.
However if you want to color the row and retain it on ward, then you would need a VB code. By retaining I mean, let say today the conditions are true and the row is blue. Now you save the file and after a month you open it. Now if you still want the book to show the colors as they were when you closed the book, then you would be needing a VB code.
Jul 19, 2010 at 10:16 PM