Clear fill color?

[Crystalguru]

Is there a fill color called clear?

Here's what I am trying to do:

If the column A <> Horse then vbRed
else
vbclear

I don't want to use vbWhite because it completely erases the lines in excel. I am just looking for the cell not to be filled.

Thanks

 

[SQLBI]

Hi,

Here's some code to set a selected cell's fill colour to 'No Fill'.

Selection.Interior.ColorIndex = xlNone

Hope this helps

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[Crystalguru]

Exactly what I needed! Thank you so much

crystalguru

 

[Bowers74]

Personally I would suggest you didn't use vbRed either. Instead use &quot;.ColorIndex = 3&quot;.

;-)



Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[xlbo]

You can always declare a constant

Const Red = 3

you could then use

Selection.interior.colorindex = Red

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244