Share via

Conditional Formatting on Date Column contains formula.

Brown, Micah 1 Reputation point
2021-06-24T12:10:42.103+00:00

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.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,906 Reputation points Microsoft Vendor
    2021-06-25T07:26:37.57+00:00

    Hi @Brown, Micah ,
    Could you try to provide a sample about your problem?
    Did you want to create the Excel template or the templated was existed?
    Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.