Conditional formatting based off cell with text? (i.e. "less than
 

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.

Conditional formatting based off cell with text? (i.e. "less than
 

see response to your other posting on this


--
Regards
Roger Govier

"MikeV" wrote in message
...
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.

Conditional formatting based off cell with text? (i.e. "less t
 

What do you mean?

I have two distinct questions.
One of them I figured out, the issue in the other thread I posted about the
icon sets not functioning correctly. I switched from using percentages to
using number values.

But this issue is different.



"Roger Govier" wrote:

see response to your other posting on this


--
Regards
Roger Govier

"MikeV" wrote in message
...
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.

Conditional formatting based off cell with text? (i.e. "less t
 

I posted responses to both of your questions.
The percentage switch to numbers, and the use of Text in cells and achieving
CF.

--
Regards
Roger Govier

"MikeV" wrote in message
...
What do you mean?

I have two distinct questions.
One of them I figured out, the issue in the other thread I posted about
the
icon sets not functioning correctly. I switched from using percentages to
using number values.

But this issue is different.



"Roger Govier" wrote:

see response to your other posting on this


--
Regards
Roger Govier

"MikeV" wrote in message
...
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.