How to apply multiple colors in custom formating

PiggyChu620

New Member
Joined
Jan 24, 2019
Messages
5
Let assume that I have a worksheet with 2 columns. And if the value in the first column is "A", I wish to add a Red * in the value of the second column.


I managed to add a * in the second column by using the conditional formating with custom format [Red]!*@.


But it turned the whole thing red!!!


I just want the * to be red! Is it even possible to accomplish such a task!?


I had tried to add [Black] after the *, but it throw me an error message!


And I can't find any Reset Operator on Google!


So it will be very nice if someone could teach me how to do it!


Much appreciated!!!
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hello,

You should make your life easier ... and add your Red * in a Third Column (width 2 ) ...

In addition this will prevent you from transforming your Values into Text ... :wink:

Hope this will help
 
Upvote 0
can you use an IF statement in column B and then use conditional formatting to change the colour ?
 
Upvote 0
Hello,

You should make your life easier ... and add your Red * in a Third Column (width 2 ) ...

In addition this will prevent you from transforming your Values into Text ... :wink:

Hope this will help

Unfortunately, My BOSS won't allow that!!! :(:mad::crash:
 
Upvote 0
Unfortunately, My BOSS won't allow that!!! :(:mad::crash:

Sad News ...

Your BOSS is totally incompetent ...!!!

Take the time to explain that IF you are adding a character into a cell where a number is located ...

the number is transformed into TEXT ...

And then Good Luck to manipulate your ' ex - numbers ' for your calculations ...

Tell him also ... Excel is NOT a stupid WORD PROCESSOR ...!!!
 
Upvote 0

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top