Related:
- Shade the rows for different working days
- Shade the last 3 days in color .. help! ✓ - Forum - Office Software
- Your account has been locked because we need to confirm your age. please complete the form below within 28 days to regain access ✓ - Forum - Facebook
- How to stop today function date changing every day in excel - Forum - Excel
- Time of day clock stopped - How-To - Laptop computer
- Excel/VBA - A macro to change the color of a row - How-To - Excel
1 reply
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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.
Report
Carman
I get what you mean. Thank you very much!
