Help with conditional formatting?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 13 Mar 2007 21:57 GMT

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

Reply to this Message

jan - 13 Mar 2007 22:08 GMT

Ed,

You should use:

=IS21<2

instead of

IS21<21

(so, use the equal mark)

Jan

Reply to this Message

Ed - 13 Mar 2007 23:36 GMT

> Ed,
>
[quoted text clipped - 9 lines]
>
> 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

Reply to this Message

Earl Kiosterud - 14 Mar 2007 03:00 GMT

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

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

>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
[quoted text clipped - 6 lines]
> How do I approach this?
> Ed

Reply to this Message

David McRitchie - 14 Mar 2007 05:28 GMT

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

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Ed,
>
[quoted text clipped - 13 lines]
> > How do I approach this?
> > Ed

Reply to this Message

Ed - 14 Mar 2007 16:20 GMT

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

On Mar 13, 9:28 pm, "David McRitchie" <dmcritchie_xl...@verizon.net>
wrote:

> Hi Ed,
> I have a page on Conditional Formatting which might
[quoted text clipped - 32 lines]
>
> - Show quoted text -

Reply to this Message

Ed - 14 Mar 2007 15:54 GMT

Earl:

VALUE was what I needed! Thank you!
Ed

> Ed,
>
[quoted text clipped - 18 lines]
>
> - Show quoted text -

Reply to this Message