Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
Conditional Formatting based on text? | Excel Worksheet Functions | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
Conditional formatting based on text | Excel Worksheet Functions |