johnhiro007
asked on
How to add a pop up and Grey out text in Excel 2007
I am trying to add a pop up window to my file. I want the pop up to be displayed when each time mark is up so that my tech can leave and not go over that time, that way we are not billing an extra amount for only 2 minutes. Aslo we would like for when the time passes the actual time that it automatically greys out of fades so that it is less noticeable at a quick glance. Is there any way to do this with either a macro or a formula. Each time is base on the start time on the form. 2010-08-06---TimeIncrements.xlsm
Normally to insert a column I would select the entire column, and then using the popup menu select insert....This would insert another column adjacent to the highlighted column... For some unknown reason the insert command on my popup menu is now showing as grayed out.. Using the same method, but for a row instead of a column works OK I have tried removing Excel totally and reinstalling, however the menu still remains greyed out... Any ideas would be appreciated Thank you Stephen
Sorry John! I was trying to set as a new question. I belive I pasted in wrong window.
For your solution, you have right click on the cell and click on add comment. This will add the pop up comment.
ASKER
Right clicking on a cell to add a comment is only for that perticular cell. What I need is one for the whole file. once the file is open it will altert me to let me know that I am coming up on the time that I need to leave by in order to make it a ahole hour and not go over that hour mark.
what portion would you like greyed out once the marker is met?
you have :30 increments did you want this to happen each :60 ?
thanks
you have :30 increments did you want this to happen each :60 ?
thanks
ASKER
at the 30 minute increments.
what needs to be grayed out?
ASKER
I must have missed that.
Here is what I want greyed out...
If the Leave by time is past the current time I would like the whole row to be greyed out. If the current time is past 9:45 then I want the text in row 2 to be greyed out. I hope that helps.
Here is what I want greyed out...
If the Leave by time is past the current time I would like the whole row to be greyed out. If the current time is past 9:45 then I want the text in row 2 to be greyed out. I hope that helps.
how did you want the time to be analyzed - determine elapsed time by system's time, determine timer based on opening the file (relative timing [ignoring start time, etc])?
If you use system time it will determine the time elapsed from start time/date
If you use relative time the timer will start when the file is opened (e.g. it starts counting seconds once the file is opened ignoring current time date, etc.)
If you use system time it will determine the time elapsed from start time/date
If you use relative time the timer will start when the file is opened (e.g. it starts counting seconds once the file is opened ignoring current time date, etc.)
ASKER
Great Question! Thanks for bringing that up.
It would be the system time only.
It would be the system time only.
I've implemented a timer to the excel page once you click on the sheet and click off of the cell.
Once the hours elapsed from "start time" reaches the timepoints : 0.5, 1.0, etc the 0.5, 1.0, etc gray out.
Let me know what else you need or if you wanted something else.
Thanks!
TimeIncrement.xlsm
Once the hours elapsed from "start time" reaches the timepoints : 0.5, 1.0, etc the 0.5, 1.0, etc gray out.
Let me know what else you need or if you wanted something else.
Thanks!
TimeIncrement.xlsm
ASKER
It works!!! That is so perfect. Is it possible to get Row 2 form column c to h to be greyed out, and instead of a grey fill can we just have the text change to a very light grey?
I can make it the way you want. Just let me know. *donations are accepted* LOL.
You can go to "conditional format" and "manage rules" to change the conditional format style I placed on the rows.
See how you like this format:
I grayed out the rows with fill and slight contract (darker gray text color than fill)
TimeIncrement.xlsm
Conditional-Format-Row.swf
You can go to "conditional format" and "manage rules" to change the conditional format style I placed on the rows.
See how you like this format:
I grayed out the rows with fill and slight contract (darker gray text color than fill)
TimeIncrement.xlsm
Conditional-Format-Row.swf
I meant light contrast oops.
The row(s) will gray out after the respective hours column(s) have been reached.
You can easily change the format style by going into conditional format
Manage-Rules.png
Lots-Of-Rules.png
Change-Rule.png
Rule-Format.png
The row(s) will gray out after the respective hours column(s) have been reached.
You can easily change the format style by going into conditional format
Manage-Rules.png
Lots-Of-Rules.png
Change-Rule.png
Rule-Format.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent Solution. Works perfectly for exaclty what was needed.