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

  • Thread starter Thread starter velasquez.m
  • Start date Start date
V

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.
 
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 %
 
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 -
Click to expand...

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...?
 
Back
Top