+ Reply to Thread
Results 1 to 2 of 2

Sperate coloured data

  1. #1
    Registered User
    Join Date
    06-29-2021
    Location
    AUS
    MS-Off Ver
    Microsoft Excel
    Posts
    1

    Post Sperate coloured data

    Hi, I want to show all of the red Scanned data in a separate column and all of the red JDE data in another column.
    Last edited by sammual; 06-29-2021 at 04:54 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: Sperate coloured data

    1. Without a sample sheet, that means almost nothing.

    2. Colour is not something that Excel can generally handle well with a formula. it usually needs VBA.

    3. Read the yellow banner (top) about sample sheet and post a SMALL sample with manually calculated expected results.
    Glenn



+ 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] Look and return and sperate part numbers with
    By pmw19800 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2021, 01:19 PM
  2. Separate Timetables into sperate sheets
    By madmoo84 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-27-2021, 07:41 AM
  3. [SOLVED] Formula to sperate First Name and Last name
    By rizmomin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-24-2020, 04:27 PM
  4. Sperate an IP from a String of cell
    By BraveR in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-28-2014, 07:51 AM
  5. How can I count coloured cells (coloured using Conditional Formatting)
    By franfry in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-15-2013, 02:40 PM
  6. VBA Code to insert dynamic data from sperate workbook to chart
    By Policeme21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2012, 04:33 PM
  7. sperate from the space, in text, in the same cell
    By Fam via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-31-2006, 12:25 PM

Tags for this Thread

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