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...
Formulas & Functions
Requests
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 05, 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.