VISHAL120
01-25-2012, 07:11 AM
I want to paint the cells for which conditions is met that is the end date and delivery date equal to that to the calendar date.
I know it’s easier with conditional formatting as I have done it in the example attached to show this.
But my problem is on my data I have already used the 3 conditions formatting and the only option now is to do it with VBA.
Can someone just guide of how can I do this with VBA.
Please have a look at my attachement.
Many thanks for the help.
:banghead:
I know it’s easier with conditional formatting as I have done it in the example attached to show this.
But my problem is on my data I have already used the 3 conditions formatting and the only option now is to do it with VBA.
Can someone just guide of how can I do this with VBA.
Please have a look at my attachement.
Many thanks for the help.
:banghead: