1-Click Quick View: Review & Feature, Fix or Focus Request [Gold & Silver]
Hello Members,
The training we have for this week that I have shared with you was about the Amazing 1-Click Quick View. If you have not seen it yet, you can view it right here on YouTube.
Now that the training has been released, I am looking for your feedback to make this even better, just for you, our incredible Patreon Members.
So, what Feature can I add for you? Did you find an issue you want me to fix? Or is there a particular area you would like me to focus on?
Please comment your ideas and feedback to any of these below and I will do my best to not only create an updated workbook but release a private training video next Monday, right here on Patreon.
I am looking forward to hearing from you and thanks so much for your support.
Regards, Randy
Comments (4)
HI Benjamin it is certainly possible using a date-based conditional formatting along with the Today formula such as If (Today()-A1>15,True,False) You can then add additional colors based on different #'s and rules. Thanks for the great question
Hallo Randy, I haven't watched the whole tutorial till now, but what come up to my mind is the question in how fare it is possible to give cells with a date a certain background colour pending on the condition (green, yellow, red pending on the condition of how "old" the date is (green = okay, yellow = e.g. 14 days before expiring, red = expired))
Hi Randy. As per our previous message exchange, I would love to modify this to something that doesn't have the quick view when the user clicks anywhere on a row, but, rather, have a field or shape on the end of a row (ie the last cell, perhaps) and when they click that then the quick view pops up. That way the user can, be default, look at the sheet in the normal way and only when they need to they'd be able to click the Quick View cell / shape / button. Hope that makes sense. Martin
HI Martin, its a great idea and I will be adding it into the Feature, Fix or Focus update on this. Much appreciated