Thanks Sharon for the Excel tip! I did change my procedure a little. On the last step where you were coping and pasting the TOC link in the other pages, I selected the remaining pages, after I had done the first one, and pasted the link into all of the at once. Again, thanks! This is a neat trick to expedite the building of a database.
Off topic with this comment. I've been watching Sharon's videos for about a week and have learnt so much. Fun fact she has sectoral heterochromia in the left eye just like myself. Such a rare sight to see 😉
Hello! I'm so glad you have found my videos helpful and that you noticed my eyes - I rarely meet anyone else who has it. Usually people don't notice that it is actually two colors in one eye. Best of luck to you. Thanks for watching my videos!
Great video! Off topic question. Can a billable form be created with quick parts? If so how do you save it? I created a form but when I re-open it, I get an unreadable content message.
I have 1 tab with 23 rows & columns to AQ. Each cell has a number ranging from 1 to 20. What I want to have in tab 2 is the cells change colour based on the number being -1 (dark green), -2 (red), +1 (yellow), +2 (light green) compared to the data in tab 1. I know its conditional formatting but I don't know how to set it up, please can you help? Or link me to a video?
Here is the hyperlink formula used in this video (replace "Index" with your own sheet name):
=HYPERLINK("#'"&[@Index]&"'!A1",[@Index])
Thanks. You remind me of Tina Fey.
Thanks Sharon for the Excel tip! I did change my procedure a little. On the last step where you were coping and pasting the TOC link in the other pages, I selected the remaining pages, after I had done the first one, and pasted the link into all of the at once. Again, thanks! This is a neat trick to expedite the building of a database.
That is perfect! Thanks for sharing your tip there. That is a great way to copy that automatically. Thanks for watching!
Your video’s are always so helpful and informative! Thank you Sharon!
Thanks so much for watching, Linda!! Glad you find my videos helpful! 😊
Off topic with this comment. I've been watching Sharon's videos for about a week and have learnt so much. Fun fact she has sectoral heterochromia in the left eye just like myself. Such a rare sight to see 😉
Hello! I'm so glad you have found my videos helpful and that you noticed my eyes - I rarely meet anyone else who has it. Usually people don't notice that it is actually two colors in one eye. Best of luck to you. Thanks for watching my videos!
Great video! Off topic question. Can a billable form be created with quick parts? If so how do you save it? I created a form but when I re-open it, I get an unreadable content message.
I have 1 tab with 23 rows & columns to AQ.
Each cell has a number ranging from 1 to 20.
What I want to have in tab 2 is the cells change colour based on the number being -1 (dark green), -2 (red), +1 (yellow), +2 (light green) compared to the data in tab 1.
I know its conditional formatting but I don't know how to set it up, please can you help? Or link me to a video?
How to use Insert menu, Text Group, Quick parts ka ,(Insert Field) option.
Please make video of this option (Insert Field) and summaries it.
Thank you for watching!