Conditional layout only on a specific part of a cell

[HosteDenis]

Hello,

I know how conditional layout works and have used it with success in the past. I'm now stuck with a problem, but I'm not sure if there's a solution at all! If so, I hope you guys know it and I'll be forever thankful.

Ok, here's the thing. I have several cells in my excel file that, through a formula, return a value. This value may or may not contain the '+'-character. So basically, just a +, or a plus-sign (I added the parenthesis for clarity).

I'd like the + to be superscript. It's not part of a mathematical formula (as in 3+6), it's part of a string (as in ret^+, just a way we label things). So basically, I want some kind of conditional layout on the cell that says if it contains a plus, superscript the plus (but not the rest of the cell). A cell will at most contain one plus.

No idea how to do this... Is there a solution at all?

Thanks in advance!

Denis

[Ron Coderre]

If you're looking for a formula that will format part of a cell...Then, No.
You'd need to use VBA to effect the formatting changes.

[Saarang84]

Hi Denis,

Is this what you need ?

Say, if cells A2 and A3 contains A+BCD+FDF+ and 123+233+ respectively, then the below formula (when used in both cells) gives you the output as +ABCDFDF and +123233 respectively.

Please Login or Register  to view this content.

[HosteDenis]

Hi Ron, that's what I was afraid of, but you can't blame me for asking here and hoping there might be a way!

Saarang, not exactly. What I'm looking for is, if a cell contains the value ret+ or ed+ or 7b+, I want it to show as ret⁺ or ed⁺ or 7b⁺, with the plus character now in superscript (higher position).

I hope this clarifies it, while typing my previous post I didn't realise I could add superscript to my forum posts.

Denis

[HosteDenis]

Does anyone have an idea? I still haven't figured it out myself, I'm thinking there might not be a way, but I haven't heard a decisive no either so...

[Ron Coderre]

Here's one approach:
• Select your workbook
• ALT+F11...to open the VBA Editor
• Insert.Module...to add a general module to your workbook
• Copy the below VBA code and paste it into that module

Please Login or Register  to view this content.

• Select the range you want edited in your workbook
• ALT+F8...to open the macros window
...Select: PutSuper...Click: Run

Now the + in each ret+, ed+, and 7b+ will be superscripted.
Note: That code assumes that each of those values can only exist ONCE per cell.

Is that something you can work with?