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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting based off cell with text? (i.e. "less than80%") 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional Format Range of Cells 3
Conditional formatting / blank cells 4
Conditional formating 1
Conditional formating problem. Please help. 7
Changing cell colors 1
Excel Conditioning Formatting 3

Back
Top