Feb 19 2022 06:41 PM
Hi! I'm trying to use conditional formatting to display text alerts depending on user input. I have created a simplified example. In the given example, on sheet 2, the user will input their score (here '2', '1', or '0') in response to a given criteria (here, Criteria 1 and Criteria 2). The Alert column (E) will then display the appropriate alert based on the input. Alerts are derived from sheet 1.
The difficulty I'm having is that I need the alerts for criteria 1 and criteria 2 to appear in the same cells (E2&E3), but only appear when the use input is entered. That is, if the use enters '2' for criteria 1, the criteria 1 alerts need to show. When they subsequently enter a value for criteria 2, the criteria 2 alterts need to appear in place of the criteria 1 alerts. At present, once the criteria 1 alerts show, they remain (they're not replaced by criteria 2).
Example here: https://docs.google.com/spreadsheets/d/1zK8Y9x2Fc_SGh4BeCog667vnGZZIDs1k/edit?usp=sharing&ouid=10629...
I would be incredibly grateful for any suggestions as I'm not even sure this is possible?
Feb 19 2022 07:18 PM
Feb 22 2022 12:08 AM
Feb 22 2022 09:13 AM
Feb 22 2022 09:25 AM
Feb 23 2022 08:50 AM