Results 1 to 3 of 3

Conditional formatting with VBA

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2005
    Posts
    3

    Conditional formatting with VBA

    Hi Forum,
    1st post so please be gentle :-)

    I have read hundreds of posts but can't quite find an answer to my problem.
    Seems pretty simple but now my ears are bleeding trying to work this one out.

    Using Excel 2003:
    Basically, I need to highlight any cell in a row that is equal to or less than a range set in column "J" of the same row.

    I have attached a sample spreadsheet showing what I am trying to do.
    Columns B:D show the effect I need using Conditional formatting
    Columns F:H is where I'd like to achieve the same effect with VBA
    Column J is the values I need to lookup in F:H and then format them via font or background, not fussed.

    I can't use Conditional formatting on the final sheet as it won't work with another macro that converts it to HTML, this other macro just won't pickup the formatting when it's conditionally changed so I need to do it with VBA!

    Any help as always would be gratefully accepted from you gurus :D
    Attached Files Attached Files
    Last edited by Tigger; 11-29-2010 at 12:45 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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