Previous Topic Next Topic

Shade the rows for different working days

Solved/Closed
Carman - Jul 19, 2010 at 04:15 AM
 Carman - Jul 19, 2010 at 10:16 PM
Hello,
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?
Thanks.
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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.
Carman
Jul 19, 2010 at 10:16 PM
I get what you mean. Thank you very much!

Similar discussions

Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

Hello, I hope whoever reads this message is well!  I’ve been experiencing an issue since before Christmas and I have no idea what to do. When opening Instagram the app, it always tries to get me to update my email address. After doing the app states I won’t have access to some settings for a few days. This has been going on since December, I’ve tried updating my email address on multiple devices to no avail. (See photos) Any guidance/help would be much appreciated. Thank you! 

1 response
this account will be disabled in 28 day you only have 28 days left to request a
Chandrakantmahire -
Treasurelove -

this account will be disabled in 28 day you only have 28 days left to request a review. after that you account will be permanently disabled

2 responses
This account will be disabled in 1 day Are you sure that you want to log out? Y
Usman -
dwebb -

This account will be disabled in 1 day
Are you sure that you want to log out?

You only have 1 day left to request a review. After that, your account will be permanently disabled.

1 response
You have 30 days to request a review
Dibakar -
HelpiOS -

Hello,

Your Facebook account has been disabled. This is because your account, or activity on it, doesn't follow our Community Standards.

If you think that we've disabled your account by mistake, we can take you through a few steps to request a review. You'll need to complete these steps within 30 days to avoid your account being permanently disabled.

Please help!

1 response
This Account Will Be Disabled in 18 Days Are you sure you want to log out?
Vishwaswamy -
Vikash -

Hello,

This Account Will Be Disabled in 18 Days
Are you sure you want to log out?

You only have 18 days left to request a review. After that your account will be permanently disabled.

9 responses