Conditional formatting

[as02011961]

Hello to all,

I want to Format a text containing cell in dependence of another cell that contains an integer number.

Example:

If the number the cell is 1, the indent of the text cell should be 0.
If the number the cell is 2, the indent of the text cell should be 1.
And so on..

How can I get to a solution?

Thanks in advance for a quick help.

Regards

Andreas

[alvin-chung]

Hi Andreas, could you put up a small sample workbook, with expected result and description of how you get it?


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[as02011961]

Hello Alvin,

here is a screenshot of my Problem:

EXCEL-Problem.jpg

In dependence of the assembly level in column 1, the description should be indented. I managed that by using single columns for each level. But I want to indent the description in dependence of the assembly Level only in 1 column.

Is that possible?

Regards

Andreas

[alvin-chung]

I managed that by using single columns for each level. But I want to indent the description in dependence of the assembly Level only in 1 column.

Hi Andreas, I'm afraid I couldn't get what you mean by the quote above..


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[as02011961]

Hi Andreas, I'm afraid I couldn't get what you mean by the quote above..


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Well, Alvin,

let me explain. As You see on the attached screenshot, I have a BOM with 10 Levels. For a better overview of the structure I use a single column for each Level to put the description text into. Those 10 columns I want to replace by 1. But the optical effect should be similar to the one with 10 columns, i.e. the decription text in the single column should be indented according to the assembly level in the column before that.

Got it?

Regards

Andreas

[alvin-chung]

Hi Andreas,

One alternative that I could think of is to create a helper column with formula for the indent.

Example:
Column A: number of indent
Column B: original description without indent
Column E: this is a helper column with formula E2=REPT(A2," ") & B2 --- assume that each indent is 4 spaces, change as you wish


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[as02011961]

Hello Alvin,

thank You for answering. I will try Your solution. It Looks good for me.

Regards

Andreas

[as02011961]

Hello Alvin,

I tried Your proposal, but it didn't work! I get an error message when entering the formula =REPT(A2, " ") & B2.

Regards

Andreas

[as02011961]

Sorry Alvin,

here I am again. It works! I am using a German Version of EXCEL, the function REPT is here WIWDERHOLEN.

Sorry.

Regards

Andreas

[alvin-chung]

No worries, glad it helps.


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin