Forum Discussion

Sophia Martinez's avatar
Sophia Martinez
Copper Contributor
Dec 05, 2017

Highlight cell when new data is added to excel worksheet

NEED HELP

I have a master file of chart of accounts and accounts are created monthly. How do I set the excel worksheet to highlight new accounts added to the list of chart of accounts? See attached example excel file.

 

 

Formulas & Functions
Requests
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Dec 06, 2017

    Hi Sophia,

     

    Excel itself has no idea is that a new record or not, you need to help it. For example add one more field when the account was added and highlight all records were added back one week from TODAY(). Something like this.