Column Colors

[Bob]

Within a worksheet, I would like it to automatically color
the cell if its value falls below a certain number or goes
above a certain number. How do you do that?

Bob

 

[David McRitchie]

Please be careful in posting that you post only one question in
one newsgroup. Using the CDO (communities) web pages to
post it is probably difficult to tell if you actually posted or not.
Most of us use a newsreader to read newsgroups.

See my answer in your other posting.

 

[Max]

Try Conditional Formatting (CF)

For example:

Suppose you want the cell's background color
to change to light green if the value entered is > 10

Click on A1
Click Format > Conditional Formatting

Set under Condition 1:

Cell Value Is | greater than | 10
Click Format button > Patterns tab > Select: light green > OK
Click OK

Now test it out by entering various values into A1
some < 10, some > 10.

The cell color will change to light green with values > 10

For more info, try MVP Debra D's page on CF at:

http://www.contextures.com/xlCondFormat01.html