formula for changing cell color

[solo_razor]

hello,

Does anybody know a formula for changing cell color's within a certai
range?

regards,
nie

 

[gocush]

Try:

Range("B5:B10").Interior.ColorIndex = vbYello

 

[Tom Ogilvy]

The constant vbYellow is an RGB Long and would only be used with the color
property
Range("B5:B10").Interior.Color = vbYellow

vbYellow has a value of 65535

color indexes for specific colors are 1 to 56

yellow is colorindex 6

Range("B5:B10").Interior.ColorIndex = 6

 

[sjvenz]

In Conditional format you can sepecify if the cell is greater than 0
which would then give you a true value to change the colour of the
cell.

 

[David McRitchie]

I have a page on Conditional Formatting there is not VBA involved.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

C.F. has a limit of checking 3 conditions per cell, beyond that you
probably want to use an event macro which are installed differently
than regular macros..
http://www.mvps.org/dmcritchie/excel/event.htm#case

The big advantage of a conditional format is that it doesn't matter
how the value got changed:

 

[pikus]

On the main menu select
Format --> Conditional Formatting...

The window that pops up will make it pretty clear how to set that up.
And you can click the "Add>>" button to get up to three tota
conditional formats. - Piku