Coloring Columns

[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

 

[John Wilson]

Bob,

Conditional Formatting.
Take a look here:
http://www.contextures.com/xlCondFormat01.html

John

 

[David McRitchie]

Hi Bob,
You want to use a C.F. with AND(....) or OR(...)
depending on how you write it.

Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

=OR(A1<20, A1>70)

The cells that receive C.F. are those that are selected whtn
you create your Conditional Formatting. The formula you
enter is based on the address of the active cell.

If you wanted to color the entire row based on value in
column C you might use
=OR($C1<20, $C1>70)