adding color to cells

  • Thread starter Thread starter Sam Goody
  • Start date Start date
S

Sam Goody

When inserting a number in a cell I would like the cell to
change color if the number is < > a given range.
EX:
given range .8 upper limit,.6 lower limit. If I insert .9
the number is returned with a cell color of "Tan"; If I
insert .5 the number is returned with a cell color
of "Blue". Colors are optional.
Has anyone tried this? Iwould appreciate any help that you
can give.

Thank you,

Sam goody
 
or my webpage
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Elaborating a little bit to show you how the formulas work
inside Conditional Formatting.

With the column C selected as the column for color change
and with C1 as the activecell

Format (menu), Conditional Formatting
C.F. condition 1: =AND(C1>=.6, C1<=.8) -- Tan
C.F. condition 2: =ISNUMBER(C1) -- Blue

Or if you want the entire row to change color select
the entire sheet, and any cell on row 1 can be selected.
(note the $ for absolute column)

after making selection, Format (menu), Conditional Formatting
C.F. condition 1: =AND($C1>=.6, $C1<=.8) -- Tan
C.F. condition 2: =ISNUMBER($C1) -- Blue

for condition 1 you can use value is between, but I prefer
to use the formula, in fact the second example above asking for
one or more columns to be colored based specifically on the
value in column C show another reason to use the formulas. .

Use the format button, then the patterns tab, to assign the
color to the condition.

The objective behind a conditional formula, or filtering is for the
formula to return True (not zero), or False (zero).
 
Back
Top