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!!!
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!!!