question

BrownMicah-4081 avatar image
0 Votes"
BrownMicah-4081 asked emizhang-msft commented

Conditional Formatting on Date Column contains formula.

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.

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft commented

Hi @BrownMicah-4081,
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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @BrownMicah-4081,
I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.

0 Votes 0 ·