Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
square root | Excel Worksheet Functions | |||
change background color in cells | Excel Worksheet Functions | |||
How do I change a merged Cells background color | Excel Programming | |||
Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) | |||
Square Root in VBA | Excel Programming |