Forum Discussion
ejm-333
Jan 06, 2020Copper Contributor
Data Entry with Colour Coding
I have an existing data set which at present is being updated through ardusous manual entry and copy/paste. I want to insert a data entry form which can be used both to add new records and update exi...
ejm-333
Jan 06, 2020Copper Contributor
I should've mentioned that the data sheet will be locked at the end of the month and copied into a new sheet for the next month - so that each month's updates are seperate.
I've tried conditional formatting and it seems that it wouldn't be appropriate for say new projects or for projects removed.
JKPieterse
Jan 06, 2020Silver Contributor
I'm not sure what you mean by CF not being appropriate. Can you post a sample of your sheet perhaps? Also, I advise not to split your monthly data across multiple sheets, it makes yearly reporting difficult.