Shade the rows for different working days

 Carman -
I need a VBA code that allow me to shade the row color in blue when the date in a cell is performed in the last 3 days of working days . Otherwise, shade the row in yellow if the work is performed in the first 2 days of working days. Can anyone help?

1 reply

Registration date
Thursday January 28, 2010
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.
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

I get what you mean. Thank you very much!