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
36 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

630 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