M
MedicJimK
Guest
I am working on making an equipment check sheet in which the person filling out the form inputs information in certain areas. I would like to have certain text in a cell change color depending on the number inserted in the form (ie: Oxygen Levels), but I want the text in the form to stay (ie: On-Board Oxygen PSI, Oxygen Bottle PSI, Stretcher Oxygen PSI), and the number that goes and is placed in the cell coming from another cell to change color (ie: PSI between 0-500 would be red, PSI 500-600 would be yellow, and PSI 600-2000 would be green). I have the cell (F9) formatted as follows: ="Oxygen Bottle PSI: "&I18.
How would I make the check sheet show up this color change [Question 1]?
I would also like to add a window which pops up when you click on a certain cell so that you can input a quantity of what was found (ie: 4x4 Gauze which shows that 24 are needed) and then change the color of the text but also place the amount found along side what was supposed to be found. How would I do this [Question 2]?
As you can see I have drop down menus to select either the ambulance, or crew riding and doing the check of the ambulance. I also have check boxes that you can click on and have the box checked meaning the equipment is there. The sheet works how I have it now, but I wish to make other improvements to make it easier to find out if the vehicles were checked and have what is supposed to be in them. Also it would be easier to find out who is not doing the job of restocking the equipment. The person doing the check sheet would be filling out the form at the beginning of their shift, and before restocking if needed.
I would also like to have a timestamp in which the person filling out the form does not see it, but a supervisor can look at the timestamp to see when the apparatus was checked. How would I go about this [Question 3]?
Would this all work if the file was uploaded to Google Drive, or OneDrive [Question 4]?
Please answer all questions (four in total) above and any help with this would be greatly appreciated. Thanks.
Image will follow once my account is verified.
Continue reading...
How would I make the check sheet show up this color change [Question 1]?
I would also like to add a window which pops up when you click on a certain cell so that you can input a quantity of what was found (ie: 4x4 Gauze which shows that 24 are needed) and then change the color of the text but also place the amount found along side what was supposed to be found. How would I do this [Question 2]?
As you can see I have drop down menus to select either the ambulance, or crew riding and doing the check of the ambulance. I also have check boxes that you can click on and have the box checked meaning the equipment is there. The sheet works how I have it now, but I wish to make other improvements to make it easier to find out if the vehicles were checked and have what is supposed to be in them. Also it would be easier to find out who is not doing the job of restocking the equipment. The person doing the check sheet would be filling out the form at the beginning of their shift, and before restocking if needed.
I would also like to have a timestamp in which the person filling out the form does not see it, but a supervisor can look at the timestamp to see when the apparatus was checked. How would I go about this [Question 3]?
Would this all work if the file was uploaded to Google Drive, or OneDrive [Question 4]?
Please answer all questions (four in total) above and any help with this would be greatly appreciated. Thanks.
Image will follow once my account is verified.
Continue reading...
