Sequence SS row & column

acron shared this question 3 years ago
Answered

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.

Comments (2)

photo
1

Sorry, I couldn't find a simpler solution.

If you ask specific questions about the solution, I will try to give you a short answer.

photo
1

This is great rami, thanks for the assist. I just had no clue as to how to do it.


Thanks,


Tony

© 2022 International GeoGebra Institute