Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Condtional Formatting (2007)

    A have a spreadsheet containing data in col's A:H from row 8 onwards. I need to highlight all rows where the value in Col H is 60 or more.

    I have tried using VBA code to automate this, but cannot get it to work properly

    Attached please find sample file. You Assistance will be most appreciated



    Regards


    Howard
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Condtional Formatting (2007)

    You don't need a marco for this. You can use Excel's built-in Conditional Formatting

    Highlight cell H8 as far down as your data is
    click Format >> Conditional Formating on the menu
    select Cell Value is >>choose greater than or equal to >> input 60
    click on Format >> choose the color you want
    click OK >>OK
    and there you are
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Re: Condtional Formatting (2007)

    Hi Franciz

    Thanks for the help, much appreciated

    Regards

    Howard

Posting Permissions

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