Ah, you are asking about Excel IF function not the VBA.
the background for the cell is set with ActiveCell.Interior.Color = vbBlue
There are many good books and websites out there on VBA (Visual Basic for Applications) programing.
__________________
Sodomy non sapiens. : I'm buggered if I know
|