Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: conditional format (change shading)

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Arizona
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi! I import data each month into spreadsheets. I would like to set up each monthly spreadsheet so that if a name changed from last month's spreadsheet it gets shaded a certain color. I tried conditional formating but it won't let me refer to another .xls file, and I'm a novice with macros. Thanks in advance for any replies.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Arizona
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nevermind, I figured it out, I don't think it's the best solution, but I made a column at the end that put a "*" if there was a change, and then used conditional formating based on that column. If anyone knows a better solution, please let me know, otherwise thanks anyways.

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
  •