Solved

Need cells within a column to indent based on the condition that a value was entered into one of two columns (accounting journal entries)

Posted on 2016-09-21
2
20 Views
Last Modified: 2016-10-10
I have four columns that I make general ledger accounting journal entries in excel that is set up as follows:
Column A- Date
Column B- Account Name/Description
Column C- Debit (DR)
Column D- Credit(CR)
See below:
Screenshot of accounting entries in excelThe nature of accounting entries makes it as such that debit entries are left justified while credit entries are right justified (or indented). Is there a set of conditional formatting or excel formula to accomplish this? I ask this question setting aside the fact that I could set up a filter to take all the rows that contain values in column D and manually right justify/indent column B.
0
Comment
Question by:Lee Richardson
  • 2
2 Comments
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 500 total points (awarded by participants)
ID: 41809962
You can apply a custom number format with conditional formatting to the Account column.

Select the Account column data and add a new conditional formatting rule. Select formula and enter =D2<>"", where column D is the credit column and the data starts in Row 2. Select Format > Number and enter the format "    "@. You can adjust the indent level by adding spaces between the quotation marks.
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 41836582
Comment answers askers question.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now