Results 1 to 4 of 4

Thread: Excel 2010 Conditional Formatting/Macro

  1. #1
    Yer Da Sells Avon! keef247's Avatar
    Join Date
    Dec 2005
    Location
    Brownsville
    Posts
    1,291
    Thanks
    90
    Thanked
    10 times in 9 posts

    Excel 2010 Conditional Formatting/Macro

    Basically at work i'm doing countless databases for call logs etc and i want to cut down repetative input with either conditional formatting or a macro (whatever is easier)

    so what I want is IF column G contains the words "CB 24/06/11" for example to copy the date "24/06/11" into the Callback date column H and I want to do this for the entire column respectively.

    sorry if this sound a bit confusing... Haven't used excel in years and have got the hang of using conditional formatting to highlight rows with relevant colours dependant on the data inputted again saving time, so this would be of great help.

    here is a rough demo to give you an idea I hope this will help.



    cheers.

    oh and to note these are freely available sources off yell.com etc etc so don't flame me for data protection I have included these as a brief example...
    Last edited by keef247; 15-06-2011 at 11:36 AM. Reason: additional information
    Quote Originally Posted by Fraz regarding the Apple Mighty Mouse
    I just got so fed up with this thing for it's crappy erratically working scroll ball and poor right-click detection that I just threw it against a wall and it exploded.

    Good riddance. Wish I'd done it about a year ago.

  2. #2
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    275 times in 146 posts

    Re: Excel 2010 Conditional Formatting/Macro

    couldn't you just use =right(G1,8) ? Would take the 8 right-most characters from column G.

    You haven't given us the condition properly, ie. when wouldn't you want it to copy the date section across? If there are instances you want to ignore, then we're talking about using an IF function, but otherwise not....
    One can never stop saying Thank You

  3. Received thanks from:

    keef247 (16-06-2011)

  4. #3
    Yer Da Sells Avon! keef247's Avatar
    Join Date
    Dec 2005
    Location
    Brownsville
    Posts
    1,291
    Thanks
    90
    Thanked
    10 times in 9 posts

    Re: Excel 2010 Conditional Formatting/Macro

    cheers anyway but I figured it out... basically my comments in column G start in row 6 and with some editing this is the final working code
    Code:
    =IF(LEFT(G6,2)="CB",MID(G6,FIND(" ",G6),LEN(G6)),"")
    cheers again guys
    Quote Originally Posted by Fraz regarding the Apple Mighty Mouse
    I just got so fed up with this thing for it's crappy erratically working scroll ball and poor right-click detection that I just threw it against a wall and it exploded.

    Good riddance. Wish I'd done it about a year ago.

  5. #4
    Yer Da Sells Avon! keef247's Avatar
    Join Date
    Dec 2005
    Location
    Brownsville
    Posts
    1,291
    Thanks
    90
    Thanked
    10 times in 9 posts

    Re: Excel 2010 Conditional Formatting/Macro

    Quote Originally Posted by fuddam View Post
    couldn't you just use =right(G1,8) ? Would take the 8 right-most characters from column G.

    You haven't given us the condition properly, ie. when wouldn't you want it to copy the date section across? If there are instances you want to ignore, then we're talking about using an IF function, but otherwise not....
    this actually worked a lot better nice one!!!
    Quote Originally Posted by Fraz regarding the Apple Mighty Mouse
    I just got so fed up with this thing for it's crappy erratically working scroll ball and poor right-click detection that I just threw it against a wall and it exploded.

    Good riddance. Wish I'd done it about a year ago.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2010
    By Disturbedguy in forum Software
    Replies: 3
    Last Post: 13-05-2011, 12:38 PM
  2. Excel conditional formatting and inserting a new row
    By Anders in forum Help! Quick Relief From Tech Headaches
    Replies: 0
    Last Post: 07-08-2009, 05:10 PM
  3. Excel help (Conditional Formatting)
    By Workaholic in forum Software
    Replies: 3
    Last Post: 04-02-2008, 01:31 AM

Posting Permissions

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