Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Conditional Formatting with Drop Down Menus
My problem is as follows -
I am creating a spreadsheet to monitor response times to incoming incidents to my department. There are three different types of incidents - Critical, Major and Minor. Each of these have different times that we should respond in. Critial : 30 Minutes Major : 1 Hour Minor : 24 Hours When entering information into the spreadsheet I have a drop down menu so the user can choose Critical, Major or Minor. I have a simple formula that if you enter the incoming date and time and the response date and time it works out the time difference. I have also used conditional formating to highlight fields in red that take longer than 24 hours. Is there any way to set values for each of these items on the drop down menu. For example if the user chooses Critical and the response time is worked out to be over 30 minutes it highlights the field in red. But if the user chooses Major it only highlights the field if the response time is over 1 hour. Many Thanks, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Value to Trigger Conditional Formatting | Excel Worksheet Functions | |||
Creating Drop-down menus with subset drop-down menus | Excel Worksheet Functions | |||
Conditional Formatting a drop down list | Excel Worksheet Functions | |||
Drop Down Menu Conditional Formatting | Excel Discussion (Misc queries) | |||
Formatting (conditional?) a drop down box selection | Excel Discussion (Misc queries) |