Get_Involved
Active Member
- Joined
- Jan 26, 2007
- Messages
- 383
In Cell D16 I have a Date. Is there a VB Code for this Idea?
If up till 90 days before the date the cell background remains white or no fill.
If from 90 days to 60 days, the cell background turns green.
If from 60 days to 30 days, the cell background turns yellow.
If 30 days or less the cell background turns red.
I have tried conditional formatting each cell, and can only get one cell to change to the color.
I know I don’t know exactly what I am doing with code
If its VB Code would you Please explain what page to put the code.
Any help would be appreciated.
Thanks
If up till 90 days before the date the cell background remains white or no fill.
If from 90 days to 60 days, the cell background turns green.
If from 60 days to 30 days, the cell background turns yellow.
If 30 days or less the cell background turns red.
I have tried conditional formatting each cell, and can only get one cell to change to the color.
I know I don’t know exactly what I am doing with code
If its VB Code would you Please explain what page to put the code.
Any help would be appreciated.
Thanks