Okay so im trying to change the text colour of random cells within a selection of cells based on another cells value.

For instance, i have 100 cells total each with the letter "O".

I have a separate cell which displays a % value based on the users input into another cell.

So, if this % value returns for example, 30%, then i want the text of 30 random cells within my selection of 100, to change colour to RED.

Is this possible? Forgive me if i haven't explained this very well, it does sound quite overwhelming.