Code for Conditional format

  • Thread starter TUNGANA KURMA RAJU
  • Start date
T

TUNGANA KURMA RAJU

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
 
S

ScottO

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" <[email protected]>
wrote in message
| 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
 
T

TUNGANA KURMA RAJU

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.
 
D

Dave Peterson

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

Roger Govier

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
 
Top