VB Code Help

[Get_Involved]

Is there VB Code to get a cell date to change to different colors in this format <= 30,20,14,7] days?
Thanks in Advance

 

[cerfani]

you can color a cell based on it's value with conditional formatting, you don't need to code it.

 

[ajamess]

You could just do this with conditional formatting.

If you absolutely want to do it with VBA I would use if statements for your timeframe like:

if cell.value - ReferenceDate <= 7then
    cell.interior.colorindex = color1number
elseif cell.value - ReferenceDate <= 14 then
    cell.interior.colorindex = color2number
    ......
End if

Where the cell is the cell you're looking to change the color. ReferenceDate is the date you're finding the difference of 30,20,14 etc days from. (I'm not sure if you're doing this from a todays date, or some other reference date).

And the color values are the numbers of the colors you want from: https://msdn.microsoft.com/en-us/vba/excel-vba/articles/colorindex-property

 

[Get_Involved]

Thanks
For your response

 

[Get_Involved]

Thanks ajmess
I have pre determined date in Cell C15