Consulting

Results 1 to 2 of 2

Thread: Comparison formatting

  1. #1
    VBAX Regular
    Joined
    Jan 2005
    Location
    Kansas, land of Dorothy and Toto
    Posts
    36

    Comparison formatting

    I have a spreadsheet with products and prices. Is there a way to compare each value in column B with the same row value in column H, then highlight the cell with the lower value?
    I am using Word 2003 and 2007, so I'm saving everything in 2003 format.
    Alas Babylon's Trivia Questions
    Three questions a day, Monday through Friday.
    To join, send e-mail to
    alasbabylon@gmail.com with SUBSCRIBE in the subject line.
    To leave, send e-mail to
    alasbabylon@gmail.com with UNSUBSCRIBE in the subject line
    http://groups.google.com/group/AlasBabylon?lnk=li

  2. #2
    VBAX Tutor nst1107's Avatar
    Joined
    Nov 2008
    Location
    Monticello
    Posts
    245
    Location
    Use conditional formating in each column. I've done it here in your workbook.

Posting Permissions

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