How to make cell change color at specific frequency?

[Randomizer]

Hello guys,
Screenshot excel - http://scr.hu/1tm/4xsbo
So my B1 is a hyperlink to tab 'Sheet1'. So every time I click B1 the tab "refreshes".
I want the colors of A1 and A2 change every time when I go to this tab.
Let's say I want:
A1 to be Red 20% of the time, Yellow 40% of the time and Blue 40% of the time.
A2 to be Red 10% of the time, Yellow 70% of the time and Blue 20% of the time.

How can I do that? If you will give me a code, could you please explain me how to implement it in the cells? I am novice excel user.

Thank you very much!

 

[AliGW]

Cross-posted: How to make cell change color at specific frequency?

 

[Randomizer]

Hi, I am sorry for that, I didn't get a reply yesterday on another forum ( How to make cell change color at specific random frequency? ) so decided to post on 3 others because I need it asap for my project. If it will be solved I promise to post a solution.
Other places where I posted:
How to make cell change color at specific frequency?
https://www.reddit.com/r/excel/comments/5p2t6d/how_to_make_cell_change_color_at_specific/

 

[Jon von der Heyden]

Thanks for posting the links to the other threads. Please do so in future should you cross-post here again.

 

[Randomizer]

SOLVED here: https://www.reddit.com/r/excel/comments/5p2t6d/how_to_make_cell_change_color_at_specific/

 

[Jon von der Heyden]

Thank you for keeping us posted.