Hello,
Is it possible to change a cell interior color within a function or must
that be done throught a sub.
thanks
billq

you can do it in code, or use Conditional Formatting -
though this only allows three conditions.

Sub ColorTest()
Dim i As Long
On Error Resume Next
Do
Cells(i + 1, 1) = i
Cells(i + 1, 2).Interior.ColorIndex = i
i = i + 1
Loop While Err.Number = 0

End Sub

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hello,
Is it possible to change a cell interior color within a
function or must
that be done throught a sub.
thanks
billq


.

Hi Bill,

No. A function cannot change the contents or format of a cell.

Regards

Dave


"billQ" wrote in message
...
Hello,
Is it possible to change a cell interior color within a function or must
that be done throught a sub.
thanks
billq