Conditional formatting based off cell with text? (i.e. "less than80%")

[velasquez.m]

Is Excel 2007 smart enough to do this?

I have an instance where I need conditional formatting set up for a
cell
whose condition is based off of another cell.
But the second cell with the condition is a not a simple number or
percentage.
It contains a text condition like "Less than 10%" or "70% or greater".

Is this even possible in Excel?
And the text can be tweaked but for appearance's sake...as close to
the
examples posted as possible.

Any thoughts?

Thanks in advance.

 

[Roger Govier]

Hi

You could use custom Formatting of cells instead of using text.
Format>Cells>Number>Custom> "Less than" #.0%
and also "Greater than" #.0%

What will display will be Less than 10.0% but the underlying value will
still be just 10%
Use Conditional Formatting as described in your previous posting, using
Numbers not %

 

[velasquez.m]

Hi

You could use custom Formatting of cells instead of using text.
Format>Cells>Number>Custom> "Less than"  #.0%
and also "Greater than"  #.0%

What will display will be Less than 10.0% but the underlying value will
still be just 10%
Use Conditional Formatting as described in your previous posting, using
Numbers not %

--
Regards
Roger Govier










- Show quoted text -

Ok, thanks Roger!
Sorry about jumping from thread to thread, I'm not sure how things are
moved and duplicated here and got a bit confused...?