+ Reply to Thread
Results 1 to 11 of 11

conditional formatt

  1. #1
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    conditional formatt

    I,m using word 2007 and would like to use a conditional format on an employee list as to not duplicate names at machines is it possible using word

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: conditional formatt

    Word does not have a conditional formatting feature (like the one in Excel). You have not given a complete description, but do you want to create a table, then highlight any names that are duplicated?

    Here are the two ways that I would do this:

    1. Create the list in Excel, with the appropriate conditional formatting. When complete, copy and paste into Word
    2. Create an embedded Excel Object in Word, then apply the appropriate conditional formatting.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: conditional formatt

    A quick google search did not turn up anything that will do what you want, but why not use excel instead? IF you need to do any calcs/analysis, excel is made for that
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: conditional formatt

    Thanks for the help - will try the embedded excel

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: conditional formatt

    hmmm why embed it? why not just use it like it is? ie, dont even bother with word

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: conditional formatt

    I would agree that an Excel file is better, unless this table is just one part of a larger document and really, really has to be in Word.

  7. #7
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: conditional formatt

    For a Word table, you could use a macro like:
    Please Login or Register  to view this content.
    If you don't want to highlight the first entry, simply comment out the 'If .Found = True ' line. The highlight colour will be whatever your current default is set to.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  8. #8
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: conditional formatt

    I like your way of thinking Macropod but unable to make it work -- unfortunately its not my worksheet or it would be done on excel

  9. #9
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: conditional formatt

    You asked about conditional formatting of a table in Word, but now you're referring to a worksheet - which is an Excel term. Which is it?

  10. #10
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: conditional formatt

    Its in word week 23 Days.doc

  11. #11
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: conditional formatt

    Given that your table isn't a list, contrary to how you described it in your first post, a few changes to the macro would be required:
    Please Login or Register  to view this content.

+ 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] Returning a Day from a numerical date formatt
    By CliveH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2013, 08:23 AM
  2. Excel Date Formatt Issue
    By donnyp02 in forum Excel General
    Replies: 1
    Last Post: 04-25-2008, 10:43 AM
  3. HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT
    By conditional format in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2006, 12:40 PM
  4. [SOLVED] Time formatt
    By Bash in forum Excel General
    Replies: 8
    Last Post: 11-07-2005, 05:55 PM
  5. Cell Format Changes When Data Is Entered - Not Conditional Formatt
    By SundanceKidLudwig in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-30-2005, 10:05 AM

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