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
22 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
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…

770 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