Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
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
Medium Priority
?
50 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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

722 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