compare dates in column with unique date on current month

[bmbalamurali]

Best Wishes to all,

I have attached an excel contains in
Col A - Name
Col B - Status (pending, hold, done...etc) status of the work of the people
Col C - reported date


If the status in Col B is "Pending", then VBA should check if the reported date of the concerned id greater than 12th of the current month...
and highlight as red. (date is always unique but the data will change on every month..)

if i would want to compare between current date, i would have used conditional formatting or simple codes i get online...

But, using unique date on current month is seems very difficult for me can any one help me in this please....


Thanks in advance.....

[MarvinP]

Hi Bala,

I hate to write VBA code when I don't think it is really needed. See the Conditional Formatting solution in the attached. Isn't this what you really want?

=AND($C2="Pending",$B2>=DATE(YEAR(TODAY()),MONTH(TODAY()),12),MONTH($B2)=MONTH(TODAY()))

[bmbalamurali]

Hello Marvin,

Thanks a lot... this was exactly i expected.... doing tricks in excel is an ectasy...

VBA is surely not required for the above....but,
Is it ok for you to provide me any VBA codes to deal this kind of scenario... as this would help me in future...

Thanks in advance...

[MarvinP]

OK Bala, because you gave me some rep, here is some VBA to do what I think you want. Before running this you should delete all your Conditional Formatting formulas for this column.

Please Login or Register  to view this content.

[bmbalamurali]

Thanks a lot Marvin...