+ Reply to Thread
Results 1 to 2 of 2

VBA Conditional Formatting to Grey Out Certain Cells in Target Row

  1. #1
    Forum Contributor
    Join Date
    12-22-2015
    Location
    San Antonio, Texas
    MS-Off Ver
    2016
    Posts
    116

    VBA Conditional Formatting to Grey Out Certain Cells in Target Row

    I need VBA, not conditional formatting, for when a person selects a client and a specific test associated with that client to render certain cells in that row grey and locked. If someone can create easy-to-read VBA (for this dummy) and explain what each thing means for row 3, I can modify it for the other rows. Keep in mind that this is for a table, and that it will be expanding over the course of a year with added entries. To my chagrin and dismay, I've tried seven books and numerous Internet fora to no avail. I’ve attached the file. This is for Excel 2016.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: VBA Conditional Formatting to Grey Out Certain Cells in Target Row

    What are the conditions to turn grey cells, and which cells to turn grey ...?
    - Battle without fear gives no glory - Just try

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional grey-out and disabling of cells
    By jman0707 in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 04-05-2021, 06:23 AM
  2. Conditional Formatting - Percentage of Target
    By Barrera006 in forum Excel General
    Replies: 4
    Last Post: 12-21-2015, 04:57 PM
  3. Conditional Formatting to show progress against a target
    By shauncasey in forum Excel General
    Replies: 1
    Last Post: 06-05-2015, 06:40 AM
  4. RAG Status based on OLD / New Target (Conditional Formatting)
    By batchy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2014, 11:45 AM
  5. Conditional Formatting - Grey Out and Lock A range based on a cell value in that range
    By Excelgnome in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2012, 07:31 PM
  6. Conditional formatting in relation to a target
    By zawadzki in forum Excel General
    Replies: 0
    Last Post: 11-15-2011, 03:29 PM
  7. Conditional formatting in relation to a target
    By zawadzki in forum Excel General
    Replies: 15
    Last Post: 09-29-2011, 04:07 PM

Tags for this Thread

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