Using this formulae
=(DATEDIF(B2,TODAY(),"m")>=IF(OR(D2=1,,D2=2,),6,12)
This is working to change the colour if the date is past 6 or 12 months. However this is also colouring the empty cells too.
I would like empty cells to not be edited so I have created another condition
=""
but I am unsure on the settings to go with it and it isn't currently working.
Can anyone tell me where this is going wrong?
Excel1.jpg
Bookmarks