Formattinb cells

Giganews Newsgroups
Subject: Formattinb cells
Posted by:  Charles (ce.mas…@telkomsa.net)
Date: Sun, 14 Jan 2007

Hi
Is it possible to change the background color of a column of cells depending
on the value
of the cell at the top of the column.
I have written a macro to do this but can't find a statement to do this:

worksheets(:Sheet1").cells(cl,rw).backcolor = QBColor(14)

Error message method not supported and nowhere in the help can I find an
answer.

Suggestions would be appreciated

Thanks

Charles

Replies