Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: conditional format or macro and how? (ALMOST FINISHED with

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a excel "List" - one column in the list is "Date". There are multiple records (rows) with the same value in the "date" field/cell. I need all rows that have the same date value to be the same fill color. Basically I need to color code records of like dates. (The entire rows, not just the date cells)

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Keith

    Erm wanna colour them rows subect to the date eh!

    OK look conditional format can do this, but i guess you have billions of date, how nmany>

    I have code that will do this if date in one col.. can edit to another col as we go.. does this help i ahe 25 conditions in VBA that colour rows red blue what ever, subject to a word like:
    Jack = Blue
    UK = Red
    and so on....


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Guest

    Default

    well right now there are not any dates in the list (I am developing a list with a userform entry for a project and this is the last thing I need to do) but yes, there could be many many different dates. I don't care if colors repeat themselves as long as the same color is not directly above or below a row with a different date. I have no way of knowing what info will be in any of the fields corresponding to the dates so saying the jack=red won't really work I don't think cause I dunno if or where "jack" will show up in the list.. I may not be understanding what you are askin me though..

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    I really wanna help - ive lost the plot !

    Can you mail the sheet on JackintheUK@hotmail.com

    Remove comfidential stuff and unprotect passwords, ill try to add some code to kick the date bit to colour row .... might work might not! cant promise if billions of dates wizzing about... worth a try or not?


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ok - sent THANKS

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think I figured out a workaround.. trying it now

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey wanted to let you know I found a workaround so you could stop working on a solution for me (if you had even got to it yet)... I used teh conditional format and a <> formula to set borders It isn't exactly what I wanted but it will do..

    Thanks for the help anyway!

    Keith

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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