I want to change the background color of cells, if value is a square root.

G

George C.

I'm looking to change the background color of cells in my
multiplication table, if the value in the cell is a square root.

Following is a portion of the code that a responder here provided on
my original post.

It works fine, and I've not had to change it, but I now wish to change
the cell's background color as described above.

I can't figure out from the book or from online help how I'm even
supposed to access the background's color, let alone change it in the
code.


For ir = 1 To noRows
For ic = 1 To noCols
Cells(ir, ic).Value = ir * ic
Next ic
Next ir

I suspect I have to enter something like "IF ir = ic, THEN . . . . "
before the "Next ic" statement.

TIA
Hrundi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to reference one cell in a range of one or more cells 4
Adding a value to a field that is not on a form 1
Cell Background Color Change --> Change Event 5
change the background color of a cell in access 2010 5
How to replace the background color of all cells from light green to light blue? 5
Change the color of a range of cells. 6
changing the default background color of selected cells... 2
How do I pass a value in a range command 5

Top