I created a 10x10 array that serves as a multiplication table. I wanted to use conditional formatting to easily highlight all the perfect squares (e.g. 4,16,25,36...)
Is there anyway I can do this by entering in a formula into conditional formatting? I have a basic idea of how I could do this-- =B2=POWER(SQRT(B2),2)... I am confused on how I could do this in conditional formatting formulas.
Any ideas?
Bookmarks