Help with conditional formatting?

[Ed]

I am trying to set the conditional formatting on cell C21 so that if
the value in cell IS21 is less than 2 the cell changes color. Then I
want to copy this down column C so it evaluates across each row.

I tried using FormulaIs IS21<2, but (a) it didn't change color, and
(b) when I tried to copy down, every row had "IS21", rather than
changing rows.

How do I approach this?
Ed

 

[jan]

Ed,

You should use:

=IS21<2

instead of

IS21<21

(so, use the equal mark)

Jan

 

[Ed]

Ed,

You should use:

=IS21<2

instead of

IS21<21

(so, use the equal mark)

Jan

Apologies for the typo - I did use the = in putting in the formula. I
went back and did it again just to make sure - no change.
Ed

 

[Earl Kiosterud]

Ed,

Make sure that C21 is the active cell when you set this up. Then when you copy the cell,
the formula will change per relative cell references. Make sure you've set a format. Make
sure IS21 is a number. If IS21 is formatted text (or there's an apostrophe in front of the
number in it), this won't work. If that's the case, use =VALUE(IS21)<2

 

[David McRitchie]

Hi Ed,
I have a page on Conditional Formatting which might
help you get started and help with quite a few examples.
http://www.mvps.org/dmcritchie/excel/condfmt.htm
you might also watch "About Conditional Formatting" video at
http://www.datapigtechnologies.com/ExcelMain.htm

 

[Ed]

Earl:

VALUE was what I needed! Thank you!
Ed

Ed,

Make sure that C21 is the active cell when you set this up. Then when you copy the cell,
the formula will change per relative cell references. Make sure you've set a format. Make
sure IS21 is a number. If IS21 is formatted text (or there's an apostrophe in front of the
number in it), this won't work. If that's the case, use =VALUE(IS21)<2

--
Earl Kiosterudwww.smokeylake.com







- Show quoted text -

 

[Ed]

David:

That's a lot of info! Thanks for the link. I'll have to delve deeper
when I have more time. I think there's a lot there that I've been
missing because I don't understand it.

Ed