Forum Discussion
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...
Have you considered using Conditional Formatting?
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.
- 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.