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).

OK. How about this one. I want to conditionally format one cell or a range
of cells based on the condition or value in a totally different cell or range
of cells. How would I do that? Like color fill cell C2 yellow if cell H20
equals Y. And macros are OK. I just don't know the terms or commands I
would use to program that stuff.

Thanks to anyone that can help.

"JulieD" wrote:

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).

Leon

You can use Conditional Formatting to achieve this.

e.g. select C2 and FormatCFFormula is: =H20="Y"

Select Yellow from the FormatPatterns and OK your way out.

Enter Y in H20 and watch C2 turn yellow.


Gord Dibben Excel MVP

On Wed, 18 May 2005 12:52:04 -0700, "LeonB"
wrote:

OK. How about this one. I want to conditionally format one cell or a range
of cells based on the condition or value in a totally different cell or range
of cells. How would I do that? Like color fill cell C2 yellow if cell H20
equals Y. And macros are OK. I just don't know the terms or commands I
would use to program that stuff.

Thanks to anyone that can help.

"JulieD" wrote:

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).