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

  • Thread starter Thread starter MikeV
  • Start date Start date
M

MikeV

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.
 
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.
 
I posted responses to both of your questions.
The percentage switch to numbers, and the use of Text in cells and achieving
CF.
 
Back
Top