I have a Excel Template, having Three sheets in it. The Sheet1 (Summary) contains Cell(c) whose value is depend upon Some other cell on other sheet. I have apply conditional formatting rule on Summary sheet Cell "c" that is format cell if cell value contains Current Month in Date occurring then apply Background color "Yellow". When entered data in Sheet#2 and Sheet#3, summary Sheet Column "c" shows Date but does not show Yellow Color for Current month dates in cell.