Results 1 to 10 of 10
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Conditional formatting in Word (Word 2000)

    Is there a way to format all prices greater than 100 (ie: R100.00) in a long document to RED. If I recall correctly, newer versions allow the user to Find/Replace with formats?? But Word 2000 does not have this. If I need to revert to VBA, could anyone help with some code.

    TIA
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional formatting in Word (Word 2000)

    Word 2000 does support finding and replacing formatting. Click More in the Find/Replace dialog, then click the Format dropdown.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional formatting in Word (Word 2000)

    But this will replace all prices. If I need prices > 100 replaces to red...what then?
    Tx
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional formatting in Word (Word 2000)

    How can prices be distinguished from other numbers in the document? Is every R followed by a number a price?

    What was the significance of your remark about Word 2000 not being able to find/replace formatting if you don't want to use it?

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Los Angeles
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting in Word (Word 2000)

    it would be easy if your request was: format anything in red that is greater than R99.99. Because then you could simply search for:
    R^#^#^#.^#^# (it would find all prices greater than 99.99 - anything with 3 digits!)
    replace with formatting: font, red, and you've got it. ( you could then quickly search for R100.00 and take the red off, if this is the exact price cut off you need.)

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional formatting in Word (Word 2000)

    Hi Hans,
    Sorry for delay on this post!

    >>> What was the significance of your remark about Word 2000 not being able to find/replace formatting if you don't want to use it?
    See the dialog below: I was getting mixed up with Excels Find/Replace that has the buttons to find a format and replace with a format. My mistake!

    I guess its safe to say that you can distinguish prices as R(with numbers following). So this can be used as a fairly accurate guide to follow. Another thing I considered was: Being Word, the prices are not actual numbers so it would be difficult to find values >100. I may need to run find/replace multiple times to also replace numbers of 1000 or 10000!

    Tx
    Attached Images Attached Images
    Regards,
    Rudi

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional formatting in Word (Word 2000)

    David,
    Thanx for the suggestions. It seems this is going to be the only "fast" way of getting prices in red that are >100. I'll just run Find/Replace 2 or 3 times to get prices of 1000 and 10000 also shaded.
    Cheers
    Regards,
    Rudi

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional formatting in Word (Word 2000)

    You can tick "Use wildcards".
    Enter <code>R[0-9]{3,}.[0-9]{2}</code> in the Find what box. This means: an R followed by at least 3 digits, a period then exactly 2 digits.
    Enter <code>^&</code> in the Replace with box. This means: the text in the Find what box. Click Format to set the font color to red.
    Word will replace all amounts of R100.00 and more. You'll then have to search for amounts of exactly R100.00 to reset the font. This can be done with wildcards turned off.
    Attached Images Attached Images
    • File Type: png x.PNG (19.0 KB, 0 views)

  9. #9
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Conditional formatting in Word (Word 2000)

    <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15> - WOW - Major WOW!!!!

    I didn't know that Word has capabilities like this! This is amazing. I shudder to think of what else Find/Replace can do. I know it is a powerful feature, and I have seen it in examples that have occured in the lounge before, but this is the most extreme manipulation of find/replace I have seen to date!

    Major thx Hans...this is really awesome!
    PS: Your reply is worthy of a star - I'd say!
    Regards,
    Rudi

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional formatting in Word (Word 2000)

    If you type find replace text in the Word Help, select the item Find and replace text or other items, then expand Wildcards for items you want to find and replace, you'll find the codes that can be used.

Posting Permissions

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