Share via

Excel's Conditional Formatting to Only Part of a Cell

Anonymous
2022-05-09T13:30:20+00:00

Hi,

I am attempting to apply formatting to a part of a cell, based on the value from another cell. See the image embedded below:

It seems the conditional formatting wants to colour the text of the whole cell, but I only want part of the text coloured. Here is my conditional formatting:

I tried putting [Blue] just before "T1135" but Excel moved [Blue] to before the @ symbol.

Maybe this is not possible? Does anyone have any suggestions?

Thanks!

Kristine

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-05-09T21:15:33+00:00

    html online

    work online ?

    html ?

    if so,html with css is an option.

    <style>

    	.blue-text::after {   content: "T1135";   color: blue; }

	&lt;/style&gt;&lt;table border='1' cellpadding='2' cellspacing='0' class="self\_adjust" &gt;&lt;tr&gt;&lt;th class='tdheader'&gt;T1135&lt;/th&gt;&lt;th class='tdheader'&gt;Client&lt;/th&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;&lt;p class="blue-text"&gt;XYZ Holdings Inc&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;Clients Ltd.&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;
    0 comments