+ Reply to Thread
Results 1 to 11 of 11

Conditional formatting based on old C-column values.

  1. #1
    Registered User
    Join Date
    07-13-2019
    Location
    EU
    MS-Off Ver
    16
    Posts
    7

    Conditional formatting based on old C-column values.

    How do I write code if I have sellers’ names in column A, and I want corresponding cell value in column B to format grey if I at some previous point in time have marked that name in column A with an X in column C.

    So, the same name appears more than once but I only want to mark a name once, and then have the corresponding values for that name in column B greyed out every time I enter that name again – without having to mark it with an X every time.


    I’ve googled this in many, many different ways, but I can’t formulate the question so that google understands.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Conditional formatting based on old C-column values.

    Welcome to the forum.

    A sample workbook would help, but you could use a formula CF rule with INDEX MATCH.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-13-2019
    Location
    EU
    MS-Off Ver
    16
    Posts
    7

    Re: Conditional formatting based on old C-column values.

    I'll try again.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Conditional formatting based on old C-column values.

    Try what again? We are happy to help ...

  5. #5
    Registered User
    Join Date
    07-13-2019
    Location
    EU
    MS-Off Ver
    16
    Posts
    7

    Re: Conditional formatting based on old C-column values.

    I tried to include a sample workbook, but it didn’t work, so here’s a screenshot of it.

    Attachment 632148

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Conditional formatting based on old C-column values.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

  7. #7
    Registered User
    Join Date
    07-13-2019
    Location
    EU
    MS-Off Ver
    16
    Posts
    7

    Re: Conditional formatting based on old C-column values.

    I forgot to mention that I always insert new rows at the top, so the first entry is the one at the bottom.

    Here’s a new picture.

    Screenshot of sample workbook.png

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Conditional formatting based on old C-column values.

    Please attach the workbook, not an image of it. Instructions in post #6.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Conditional formatting based on old C-column values.

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I am providing the link for you this time.)

    https://www.mrexcel.com/forum/excel-...mn-values.html

  10. #10
    Registered User
    Join Date
    07-13-2019
    Location
    EU
    MS-Off Ver
    16
    Posts
    7

    Re: Conditional formatting based on old C-column values.

    reddit.com/r/excel/comments/cd43mm/conditional_formatting_based_on_old_ccolumn_values

  11. #11
    Registered User
    Join Date
    07-13-2019
    Location
    EU
    MS-Off Ver
    16
    Posts
    7

    Re: Conditional formatting based on old C-column values.

    Solved at Reddit.

    reddit.com/r/excel/comments/cd43mm/conditional_formatting_based_on_old_ccolumn_values

+ 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. Replies: 2
    Last Post: 09-02-2018, 01:09 PM
  2. Replies: 6
    Last Post: 05-25-2018, 03:26 AM
  3. [SOLVED] Conditional Formatting of one cell based on values in a column
    By hammer68 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-23-2016, 06:12 AM
  4. [SOLVED] Conditional Formatting Rows based on Unique Values in Column
    By drjones5 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-13-2013, 04:27 PM
  5. conditional formatting based on a series of column text values
    By stewphil in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-19-2012, 03:34 AM
  6. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  7. Replies: 4
    Last Post: 01-29-2008, 08:40 AM

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