+ Reply to Thread
Results 1 to 2 of 2

Insert columns based upon data using conditional formatting

  1. #1
    Registered User
    Join Date
    10-28-2015
    Location
    Erlanger, KY
    MS-Off Ver
    Office 2010
    Posts
    25

    Insert columns based upon data using conditional formatting

    I have a spreadsheet that I have to add 3 columns in the middle of the spreadsheet, lets say insert right before the Tax_ID column, if they do not already exist and 3 columns at the end for the file if they do not exist. I have to specific data in them if there is data in another column. A good example is... if there is a last name in column D, then I need to add 3 columns, with headers B_Type = P, C_Type = PHYS and D_type = N, if there is no last name then B_Type = G, C-Type = GRUP and D_type = N, If data in Company name has 'Hospital" then B_Type = A. C_Type = Anci and D_Type = N.... , the columns at the end would need to be added if they do not already exist and the data in those columns would always be the same... the headers would be PR_PRC,PR_AUTO,PR_PRD, that data unders the headers would be PR_PRC = "SDOC",PR_AUTO="#",PR_PRD="MD". I can send a sample of what it should look like, if that would be easier.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,283

    Re: Insert columns based upon data using conditional formatting

    Yes that would be easier

    Kind regards
    Leo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional formatting based on rows AND columns
    By HelenaF in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-04-2018, 03:52 AM
  2. Conditional Formatting for Every Two Columns Based the First Column Value
    By samjh1976 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2016, 11:59 AM
  3. [SOLVED] Conditional formatting to change colors of Columns based on data entered in Column E
    By JJFletcher in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-13-2016, 01:27 PM
  4. Conditional Formatting based on few columns
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2014, 04:11 AM
  5. [SOLVED] Auto Text insert based on IF & Conditional Formatting
    By skylinekiller in forum Excel General
    Replies: 16
    Last Post: 04-18-2014, 06:49 AM
  6. [SOLVED] Conditional Formatting based on values in two columns
    By lukestkd in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-29-2013, 06:50 AM
  7. Conditional formatting columns based on Date
    By clowrym in forum Excel General
    Replies: 1
    Last Post: 09-23-2009, 04:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1