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.....