Hi Daisy, Thank you for your inquiry. The colors of the random numbers automatically matching the top 6 numbers are convenient for me to explain the method to create the Mark Six tool. If you are interested in learning how to do this, please follow the steps below: 1 Select the range $B$9:$B$57. 2 Navigate to the "Home" tab. 3 Select "Conditional Formatting". 4 Select "Manage Rules". You can find the detailed formula to make this happen. Please let me know if you need any clarification or have additional questions!
好玩, 謝謝
@@katekwong4711 多謝收看
簡單易明, 謝謝
@@kinfaichap2838 多謝你的好評
Thanks for sharing. It is very interesting.
@@cheekoletcheung6084 thanks for watching
超讚👍
多謝收看
請詳細說明如何使random number儲存格顏色與top6#儲存格顏色相同呢?
多謝收看
有關顏色嘅效果, 係用conditional format做出來.
相關技巧可以參考下面視頻影片
th-cam.com/video/8cfUAAfZJIU/w-d-xo.htmlsi=qDSAVhNyaKccNZt4
1 在第一個示範裏面假設target 嘅cell E2 係top one number
2 將Cell 2 底色為綠色
3 在conditional format裏面, 選擇底色與Cell2是相同
4 最後出嚟嘅效果就同六合彩示範嘅一樣
在六合彩文檔裏面
按下列步驟可以查看相關做conditional format嘅formula
1 Select the range $B$9:$B$57.
2 Navigate to the "Home" tab.
3 Select "Conditional Formatting".
4 Select "Manage Rules".
如有問題再留言交流
請問你係用乜嘢function 去加嗰六個Box ?
Hi William,
1 只需按mouse 選擇 cells (2x4)
2 選擇 Home
3 選擇 Alignment 裏面嘅 Merge & Center icon
4 Cells (2x4) 就變成一個 大 Cell ( 你所指嘅Box)
how to make same color in "Top 6#" to "Randum Number" with same color ? Tks
Hi Daisy,
Thank you for your inquiry.
The colors of the random numbers automatically matching the top 6 numbers are convenient for me to explain the method to create the Mark Six tool. If you are interested in learning how to do this, please follow the steps below:
1 Select the range $B$9:$B$57.
2 Navigate to the "Home" tab.
3 Select "Conditional Formatting".
4 Select "Manage Rules".
You can find the detailed formula to make this happen.
Please let me know if you need any clarification or have additional questions!
多謝指導, 我用 365 office version, 每次set" large " funtion 時, 所得出的數字答案都不包含在 Random numbers 列內, 請問原因?謝謝.
@@kennyfok6872 多謝收看
你再檢查一下array 是否正確選定random number 範圍,不包括 #1-49。 如果再有問題,將你所做worksheet send 到我email kkleung _1022@yahoo.com
@@KKLeung 謝謝回覆, 跟著您的視頻每一步去做, 經過多次嘗試, 最後發覺要逐行funtions去輸入才可成功, 間或出現error. 換言之不能用copy formula 形式去做, 末知是否因為我用上office 365 網絡版本, 因延時而經常出現錯誤回應. 無論如何, 感謝閣下之啟發. 🙏
@@kennyfok6872 我較少用web 365 版,依個個worksheet 可以用電腦版Excel, 較舊版都無問題。
想問如果我唔想出現上期攪出嘅 6 個號碼 (特別號碼除外),如上期攪出號碼為 1, 7, 14, 28, 35, 49,我應該點做呢?謝謝!
多謝收看,如果要加上這個要求,最可行方案是加入VBA 方法,如果不熟悉啲朋友就會有些困難,這個示範方法正正是免除VBA技巧 。
@@KKLeung 謝謝回覆!現在我只好 del 上期開過的號碼,得出嘅結果就唔會出現上期號碼。(好蠢但就不需要用 vba)😅😂
請問應如何settings @@KKLeung
@@cyns2002hk 不太明白你嘅問題,可否具體再說一次
vlookup value輸入程式後, 出來仍是 #N/A , 可以怎辦? thanks
@@yoyochan4734 hi Yoyo,
你可否 copy and paste formula 俾我睇吓?
是否可以固定一些我认为唔会出个number
Hi Alan,
呢個影片主要的是用最簡單的方法跑出一個六合彩數值,當中是沒有重複密碼,如果要按你的要求設限,極有可能要用VBA 方法才可做到。
It doesn't make sense
@@JoannaIp-r4h Hi Joanna, Where I need to further explain? Thanks KK