cell colour change

[anthony]

could some one please tell me how in a visual basic macro i can change the
background colour of a cell.

[Sunil Jayakumar]

Hi Anthony,

You can try:

ActiveCell.Interior.ColorIndex = x

where x is the colour reference (6 is yellow)

Hope this helps

Warm regards

Sunil Jayakumar

"anthony" <[email protected]> wrote in message
news:[email protected]...
> could some one please tell me how in a visual basic macro i can change the
> background colour of a cell.
>
>

www.ayyoo.com/credit-cards.html

[Bob Phillips]

activecell.interior.colorindex = 3

sets it to red

--
HTH

Bob Phillips

"anthony" <[email protected]> wrote in message
news:[email protected]...
> could some one please tell me how in a visual basic macro i can change the
> background colour of a cell.
>
>