VBA to color matching cells..

[tkaran25]

Hi all,

I want to color cells (dates) in sheet2 if they match with cells in sheet1.
i've used Condtional formating to color using formula =AND(A4<>" ",MATCH(A4,Remarks,0)).
As conditional formating does not actually color cells, i need vba to do so.

i have cross-posted this question below. u can find xls sheet for ref.

Cross-posted here:
http://www.excelforum.com/excel-programming/790045-conditional-formatting.html

Pl help..thanx

 

[tkaran25]

Thanx Joe4 for ur concern.
I got my problem solved in my cross-post.