I did a basic select all from one application & pasted it into Excel
(starting a cell A1).
How do I conditionally format Column C based on the value in Column B?

What I'm looking for is:
If the row value in Column B = 1, then ident the Column C 1 time.
If the row value in Column B = 2, then ident the Column C 2 times.
etc.

To make things worse:
the range of data keeps changing (it may be 200 rows one week & 800 rows the
next).

Hi Nicole

AFAIK you'll have to use a macro for this as conditional formatting does not
allow for indents. Is a macro solution acceptable?

Cheers
JulieD

"Nicole" wrote in message
...
I did a basic select all from one application & pasted it into Excel
(starting a cell A1).
How do I conditionally format Column C based on the value in Column B?

What I'm looking for is:
If the row value in Column B = 1, then ident the Column C 1 time.
If the row value in Column B = 2, then ident the Column C 2 times.
etc.

To make things worse:
the range of data keeps changing (it may be 200 rows one week & 800 rows
the
next).

Yes - I macro is an acceptable solution. I just need a little help and
sample....PLEASE!

"JulieD" wrote:

Hi Nicole

AFAIK you'll have to use a macro for this as conditional formatting does not
allow for indents. Is a macro solution acceptable?

Cheers
JulieD

"Nicole" wrote in message
...
I did a basic select all from one application & pasted it into Excel
(starting a cell A1).
How do I conditionally format Column C based on the value in Column B?

What I'm looking for is:
If the row value in Column B = 1, then ident the Column C 1 time.
If the row value in Column B = 2, then ident the Column C 2 times.
etc.

To make things worse:
the range of data keeps changing (it may be 200 rows one week & 800 rows
the
next).

Hi Nicole

here's some sample code, it requires you to choose column C and then run the
macro
---
Sub indentdata()

For Each cell In Selection
on error resume next
cell.InsertIndent cell.Offset(0, -1).Value
Next

End Sub
---

to use the code, right mouse click on a worksheet tab and choose view code
in the VBE window choose insert / module
copy & paste the code on the right hand of the screen
use alt & f11 to get back to your workbook
select column C
choose tools / macro / macros
find the indentdata macro
click run

Hope this helps
Cheers
JulieD



"Nicole" wrote in message
...
Yes - I macro is an acceptable solution. I just need a little help and
sample....PLEASE!

"JulieD" wrote:

Hi Nicole

AFAIK you'll have to use a macro for this as conditional formatting does
not
allow for indents. Is a macro solution acceptable?

Cheers
JulieD

"Nicole" wrote in message
...
I did a basic select all from one application & pasted it into Excel
(starting a cell A1).
How do I conditionally format Column C based on the value in Column B?

What I'm looking for is:
If the row value in Column B = 1, then ident the Column C 1 time.
If the row value in Column B = 2, then ident the Column C 2 times.
etc.

To make things worse:
the range of data keeps changing (it may be 200 rows one week & 800
rows
the
next).

You are AWESOME!!! THANKS SO MUCH.
I didn't think it would be that easy. Thanks again

Cheers back at you!
Nicole

"JulieD" wrote:

Hi Nicole

here's some sample code, it requires you to choose column C and then run the
macro
---
Sub indentdata()

For Each cell In Selection
on error resume next
cell.InsertIndent cell.Offset(0, -1).Value
Next

End Sub
---

to use the code, right mouse click on a worksheet tab and choose view code
in the VBE window choose insert / module
copy & paste the code on the right hand of the screen
use alt & f11 to get back to your workbook
select column C
choose tools / macro / macros
find the indentdata macro
click run

Hope this helps
Cheers
JulieD



"Nicole" wrote in message
...
Yes - I macro is an acceptable solution. I just need a little help and
sample....PLEASE!

"JulieD" wrote:

Hi Nicole

AFAIK you'll have to use a macro for this as conditional formatting does
not
allow for indents. Is a macro solution acceptable?

Cheers
JulieD

"Nicole" wrote in message
...
I did a basic select all from one application & pasted it into Excel
(starting a cell A1).
How do I conditionally format Column C based on the value in Column B?

What I'm looking for is:
If the row value in Column B = 1, then ident the Column C 1 time.
If the row value in Column B = 2, then ident the Column C 2 times.
etc.

To make things worse:
the range of data keeps changing (it may be 200 rows one week & 800
rows
the
next).

you're welcome and thanks for the feedback

"Nicole" wrote in message
...
You are AWESOME!!! THANKS SO MUCH.
I didn't think it would be that easy. Thanks again

Cheers back at you!
Nicole

"JulieD" wrote:

Hi Nicole

here's some sample code, it requires you to choose column C and then run
the
macro
---
Sub indentdata()

For Each cell In Selection
on error resume next
cell.InsertIndent cell.Offset(0, -1).Value
Next

End Sub
---

to use the code, right mouse click on a worksheet tab and choose view
code
in the VBE window choose insert / module
copy & paste the code on the right hand of the screen
use alt & f11 to get back to your workbook
select column C
choose tools / macro / macros
find the indentdata macro
click run

Hope this helps
Cheers
JulieD



"Nicole" wrote in message
...
Yes - I macro is an acceptable solution. I just need a little help and
sample....PLEASE!

"JulieD" wrote:

Hi Nicole

AFAIK you'll have to use a macro for this as conditional formatting
does
not
allow for indents. Is a macro solution acceptable?

Cheers
JulieD

"Nicole" wrote in message
...
I did a basic select all from one application & pasted it into Excel
(starting a cell A1).
How do I conditionally format Column C based on the value in Column
B?

What I'm looking for is:
If the row value in Column B = 1, then ident the Column C 1 time.
If the row value in Column B = 2, then ident the Column C 2 times.
etc.

To make things worse:
the range of data keeps changing (it may be 200 rows one week & 800
rows
the
next).