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 %

--
Regards
Roger Govier

<(E-Mail Removed)> wrote in message
news:9482eef6-4aa5-4163-9838-(E-Mail Removed)...
> 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.

On Feb 13, 10:21*am, "Roger Govier"
<roger@technology4unospamdotcodotuk> wrote:
> 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
>
> <velasque...@gmail.com> wrote in message
>
> news:9482eef6-4aa5-4163-9838-(E-Mail Removed)...
>
>
>
> > 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.- Hide quoted text -
>
> - 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...?