Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Code for Conditional format
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" 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 |
#3
|
|||
|
|||
Code for Conditional format
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" 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 |
#4
|
|||
|
|||
Code for Conditional format
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 |
#5
|
|||
|
|||
Code for Conditional format
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
protecting format | Excel Discussion (Misc queries) |