Code for Conditional format

A cell value is"MEDIUM & LARGE" or "LARGE & MEDIUM".Iwould like apply
conditional format for these two words two different colors,that means MEDIUM
word should have one color and LARGE word should have other color."&" string
with common color.Any give a Vb code

Is there anything stopping you from splitting the 2 results into 2
adjacent columns? If that was OK, then you could use CF easily.
Rgds,
ScottO
"TUNGANA KURMA RAJU" <TUNGANAKURMARAJU@discussions.microsoft.com>
wrote in message
news:182C87D2-5339-493B-A336-956D7AF3FA41@microsoft.com...
| A cell value is"MEDIUM & LARGE" or "LARGE & MEDIUM".Iwould like
apply
| conditional format for these two words two different colors,that
means MEDIUM
| word should have one color and LARGE word should have other
color."&" string
| with common color.Any give a Vb code

The results are based on a single formula ,thats why I can't split the
results.I have
asked Vb code,because I can't add one more column to my report even though
the results can be split using a formula.
"ScottO" wrote:

> Is there anything stopping you from splitting the 2 results into 2
> adjacent columns? If that was OK, then you could use CF easily.
> Rgds,
> ScottO
> "TUNGANA KURMA RAJU" <TUNGANAKURMARAJU@discussions.microsoft.com>
> wrote in message
> news:182C87D2-5339-493B-A336-956D7AF3FA41@microsoft.com...
> | A cell value is"MEDIUM & LARGE" or "LARGE & MEDIUM".Iwould like
> apply
> | conditional format for these two words two different colors,that
> means MEDIUM
> | word should have one color and LARGE word should have other
> color."&" string
> | with common color.Any give a Vb code
>
>
>

Format|conditional formatting doesn't work that way. It's the whole cell that
gets formatted.



TUNGANA KURMA RAJU wrote:
>
> A cell value is"MEDIUM & LARGE" or "LARGE & MEDIUM".Iwould like apply
> conditional format for these two words two different colors,that means MEDIUM
> word should have one color and LARGE word should have other color."&" string
> with common color.Any give a Vb code

--

Dave Peterson

Hi

Just an observation.
I have noticed in many of your posts, including one or two I have answered
you say you cannot add another column (to your report).

I can't imagine that you are using the full 256 columns of the sheet, so
adding a column shouldn't be a problem.
If is a question of fitting a report to A4 paper, then hiding some columns
would work, or you could make use of additional helper columns either to the
left or the right of the range of columns that you choose to use as your
report either on screen or in printed format.

Just a thought as I have thought once or twice that you are making life
difficult for yourself.


Regards

Roger Govier


TUNGANA KURMA RAJU wrote:
> The results are based on a single formula ,thats why I can't split the
> results.I have
> asked Vb code,because I can't add one more column to my report even though
> the results can be split using a formula.
> "ScottO" wrote:
>
>
>>Is there anything stopping you from splitting the 2 results into 2
>>adjacent columns? If that was OK, then you could use CF easily.
>>Rgds,
>>ScottO
>>"TUNGANA KURMA RAJU" <TUNGANAKURMARAJU@discussions.microsoft.com>
>>wrote in message
>>news:182C87D2-5339-493B-A336-956D7AF3FA41@microsoft.com...
>>| A cell value is"MEDIUM & LARGE" or "LARGE & MEDIUM".Iwould like
>>apply
>>| conditional format for these two words two different colors,that
>>means MEDIUM
>>| word should have one color and LARGE word should have other
>>color."&" string
>>| with common color.Any give a Vb code
>>
>>
>>