in H1 to h1000 put the formula =randbetween(1,20)
Then conditionally format your cells in columns A-G with
if H (row num) =1
and set format cells patterns to colour cells red.
you can choose any number between 1 and 20 in your formula, obviously.
Bookmarks