+ Reply to Thread
Results 1 to 1 of 1

Need VBA help for Conditional Formatting

  1. #1
    Registered User
    Join Date
    04-28-2008
    Posts
    3

    Need VBA help for Conditional Formatting

    I have a very large spreadsheet that shows sales data influence between two customers. Whether it be the customers billing location and shipping location or a contractor/oem and the end user. In the spreadsheet, it gives the influence customer (where $$ are flowing to for the sales guy to get credit) and the non-influence customer. When we receive the file the influence is pre-determined, however, I have a formula that automatically flips the influence to the non-influence customer based on certain criteria.

    Now, in this sheet I created a conditional format that highlights the row when clicked. The cells change color based on the criteria result in one cell.

    This is what the conditional formatting for the row looks like without VBA.

    Formula =CELL("row")=CELL("row",A9) Pertains to Cells =$A$9:$X$10001 color bright blue cell highlight
    Formula =AND(CELL("row")=CELL("row",XFA9),OR(AND($B9<>$J9,$A9=""),AND($A9<>$J9,$A9>""))) Pertains to Cells =$I$9:$N$10001 color red cell white font
    Formula =AND(CELL("row")=CELL("row",A9),OR(AND($B9=$J9,$A9=""),$A9=$J9)) Pertains to Cells =$I$9:$N$10001 color green black font

    BilltoShipToscreenshot.png

    Is there a way to convert this to vba?

    Thanks so much!!!!
    Attached Images Attached Images
    Last edited by bthomas; 04-09-2013 at 02:09 PM. Reason: Had a meeting and had to leave unfinished

+ Reply to Thread

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