Can I use conditional formatting to INDENT a cell?

[InactiveB0845]

I'm building a basic spreadsheet to teach accounting ledger entries. On credits, the account name and amount need to be indented. Can I use conditional formatting to include the indent based on the entry in the first column? If not, is there another solution?

For example, the columns would go as follows:
Debit/Credit , Account Name , Amount .

In the first column, they would enter either D or C. If they enter C for credit, then the corresponding entries in the other two columns would get an indentation.

Thanks for any help!!

Tom

 

[InactiveB0845]

I'm getting the feeling this can't be done. Any help is appreciated!

 

[Trevor G]

Take a look at this macro it will do as you want it to:

Sample before:

Excel Workbook
	C	D	E
1	Debit/credit	Account Name	Amount
2	C	Bill Jones	34
3	D	John Hall	45
4	C	Graham Kens	56
5	D	Alice Digger	67
Sheet1

Sample after running macro

Excel Workbook
	C	D	E
1	Debit/credit	Account Name	Amount
2	C	Bill Jones	34
3	D	John Hall	45
4	C	Graham Kens	56
5	D	Alice Digger	67
Sheet1

Code I created uses an IF Statement with a loop, sample shown below, I hope it helps

Sub Macro1()
Range("C1").Select
Do Until ActiveCell.Value = ""
If ActiveCell = "C" Then
ActiveCell.Offset(0, 1).InsertIndent 1
ActiveCell.Offset(0, 2).InsertIndent 1
End If
ActiveCell.Offset(1, 0).Select
Loop
End Sub