Sequence SS row & column
I want to create a sequence to manipulate through each cell of a spreadsheet; the result of the sequence would produce this result:
if(IsPrime(A1),SetBackgroundColor(A1, "Gold" ))
if(IsPrime(B1),SetBackgroundColor(B1, "Gold" ))
if(IsPrime(C1),SetBackgroundColor(C1, "Gold" )) ...
if(IsPrime(A2),SetBackgroundColor(A2, "Gold" ))
if(IsPrime(B2),SetBackgroundColor(B2, "Gold" ))
I think I would need a column increment on the outside and row increment on the inside,
I know the commands about work, but I want to dynamically find the primes within set in the spreadsheet.