Forum Discussion
Sophia Martinez
Dec 05, 2017Copper Contributor
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.
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.