Coloring Columns

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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)
 
Back
Top