Excel Cell Data Mandatory & Permanent User Entry Prompt

Greetings all and thanks in advance for any guidance on this inquiry! In short, I need to incorporate a mandatory and permanent data entry "error" prompt for certain cells where the "error" notif...

excel

ekklesia
Feb 23, 2023
Greetings HansVogelaar!

Thanks so very much for your guidance, I'm all set now per your direction! One quick follow-up inquiry: With this approach, it appears as though one has color border, text, fills, etc. at their disposal for the "error" indicator(s)-are you aware as to how one might use instead a colored circle around the cells to indicate the error, as I've yet to note that option, if in fact it exists?

Thanks in advance for your continued assistance!

Best regards,

Robert

ekklesia

Copper Contributor

Feb 23, 2023

Greetings HansVogelaar!

Thanks so very much for your guidance, I'm all set now per your direction! One quick follow-up inquiry: With this approach, it appears as though one has color border, text, fills, etc. at their disposal for the "error" indicator(s)-are you aware as to how one might use instead a colored circle around the cells to indicate the error, as I've yet to note that option, if in fact it exists?

Thanks in advance for your continued assistance!

Best regards,

Robert