Hi,
I'm trying to create a spreadsheet that will enable my team to track an event based on customer on a day by day basis. The requirement is to mark a cell in a calendar style spreadsheet with a certain colur depending on the results for that customer each day.
The problem is I could do this with conditinal formating, but I only have three conditions to use, I need five... then I thought it would be better to use data validation via a drop down list. I'd like to display a brief description of the event, success, cancel, user error etc, but have the calendar style spreadsheet updated with a colour symbol. Question is, how do I select a valdiation option, but have it display a cell value/colour rather than the wording in the drop down list?
Any help would be appreciated.
Dave C
I'm trying to create a spreadsheet that will enable my team to track an event based on customer on a day by day basis. The requirement is to mark a cell in a calendar style spreadsheet with a certain colur depending on the results for that customer each day.
The problem is I could do this with conditinal formating, but I only have three conditions to use, I need five... then I thought it would be better to use data validation via a drop down list. I'd like to display a brief description of the event, success, cancel, user error etc, but have the calendar style spreadsheet updated with a colour symbol. Question is, how do I select a valdiation option, but have it display a cell value/colour rather than the wording in the drop down list?
Any help would be appreciated.
Dave C