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