Hello Team
We require formula from cell no B5 to B25
A5 Cell have certain date and B4 cell have also certain date what is required here for macro
(B4 - A5) < 365 = red color should be filled
else blue color
loop next
(B4 - A6) < 365 = red color should be filled
note B4 is fixed cell and A column keep changing until the date is available in cell.
pls note I need to fill the color only and formula should be build within the macro and decide the color
Thanks
We require formula from cell no B5 to B25
A5 Cell have certain date and B4 cell have also certain date what is required here for macro
(B4 - A5) < 365 = red color should be filled
else blue color
loop next
(B4 - A6) < 365 = red color should be filled
note B4 is fixed cell and A column keep changing until the date is available in cell.
pls note I need to fill the color only and formula should be build within the macro and decide the color
Thanks