Results 1 to 12 of 12

VB Script to replace Conditional formating

Threaded View

  1. #1
    Registered User
    Join Date
    01-06-2010
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    53

    VB Script to replace Conditional formating

    I have a sheet that has 3 rows and 20 columns grouped in blocks of 9
    (the attached sheet will describe morein detail)

    This is a Drag Racing Team Points and Ranking sheet (large portions were removed because of size limitations)

    Group 1 is Best ET and it has 3 rows Best ET1, 2 and 3. there are 3 columns for Visit 1, same for Visit 2, 3, 4 and 5
    I am trying to make a VB Script to only allow 1 selection per group, forinstance if I enter a 1 in row 1 column 2 the (Best ET 1) will highlight and then Lock all blank cells in Visit 1 column, and the entire Best ET 1 Row through visit 5. This says that you used up your
    first Best ET points (you are allowed a total of 3 for the season)

    this is repeted for Group 2 (Best 60ft), Group 3 (Best light)

    Any Ideas on how to make this?
    Attached Files Attached Files

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