+ Reply to Thread
Results 1 to 4 of 4

Need to repeat conditional formatting down an entire column forever based on formula?

  1. #1
    Registered User
    Join Date
    10-18-2018
    Location
    Mobile, AL
    MS-Off Ver
    Office 365 (2016)
    Posts
    9

    Need to repeat conditional formatting down an entire column forever based on formula?

    My problem SEEMS simple but it's hard to put in a Google Search. I have 5 columns.

    First column - YES/NO toggle with conditional formatting to turn the cell green if YES and blue if NO. This works flawlessly.
    2nd\
    3rd \
    --> Each cell has a calculation formula for the data that works and I can repeat this formula. I need all 4 of these columns/rows/cells to look at the first column for YES/NO and highlight them all if they're "YES"
    4th /
    5th/

    Using this formula in the conditional formatting: ( =$K$8="YES" ) - the problem I'm experiencing is that instead of highlighting JUST THAT ROW THAT SAYS YES, it's highlighting the entire columns.

    I can MANUALLY enter the conditional formatting by updating the row number from K9, K10, K11, etc.

    Excel Conditional Formatting.png

  2. #2
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    633

    Re: Need to repeat conditional formatting down an entire column forever based on formula?

    Try this formula in conditional formatting:

    =$K8="YES"

    then update the applies to field
    If I've helped U pls click on d *Add Reputation

  3. #3
    Registered User
    Join Date
    10-18-2018
    Location
    Mobile, AL
    MS-Off Ver
    Office 365 (2016)
    Posts
    9

    Re: Need to repeat conditional formatting down an entire column forever based on formula?

    That solved it for me. Thanks boss!

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

    Re: Need to repeat conditional formatting down an entire column forever based on formula?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ 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 formatting based on an entire row
    By vaeevictiss in forum Excel General
    Replies: 4
    Last Post: 10-31-2013, 05:34 PM
  2. Replies: 6
    Last Post: 07-02-2013, 10:29 AM
  3. [SOLVED] Conditional formatting to entire column
    By Gard5096 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-02-2012, 06:34 PM
  4. [SOLVED] Conditional Formatting Entire Rows based on Change in Cell Value in Column A
    By Etain in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 09-26-2012, 07:31 AM
  5. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  6. Replies: 5
    Last Post: 05-03-2012, 06:06 PM
  7. Replies: 6
    Last Post: 02-16-2012, 04:52 PM

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