+ Reply to Thread
Results 1 to 8 of 8

Conditional Formatting Based on Other Cell

  1. #1
    Registered User
    Join Date
    06-03-2021
    Location
    US
    MS-Off Ver
    2016
    Posts
    12

    Post Conditional Formatting Based on Other Cell

    I currently have conditional formatting set to fill in cells in columns B:C with the red pattern. Once either YES or NO is chosen from the drop-down, that red pattern goes away. What I'm wanting now is to format the corresponding rows in Columns D:P to fill in with that same red pattern IF the corresponding cell to the left (B:C) is marked YES. Essentially- the cells are to fill in with the 'red pattern' when the user needs to fill in a value. Hence, the cells in B:C fill in red until either YES or NO is chosen, and I want the cells in D:P to fill in IF the cell to the left if marked YES, because if it's marked YES that means there is an 'impact' and the associate needs to explain the impact in D:P.

    In the example, I would want Row 39 D:P, Row 42 D:P and Row 43 D:P all to have the 'red pattern' in their cells because the column to the left of them was marked 'YES'.

    Is there a conditional formatting rule I can use for cells D:P that will format them ONLY if the cell to the left (B:C) is marked YES.

    2022-03-30_14-22-24.jpg

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016 (preparing to update to 2021)
    Posts
    7,543

    Re: Conditional Formatting Based on Other Cell

    That's exactly what conditinal formatting means if formats cells accordign to an indicated condition.
    Use the refefence of the YES and or NO cells
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    06-03-2021
    Location
    US
    MS-Off Ver
    2016
    Posts
    12

    Re: Conditional Formatting Based on Other Cell

    You would think, but for some reason I cannot get it to work. This is what I've used:

    Cond Form based off formula. Formula is: =$B$5=YES . Formula is applied to cells: =$D$5:$P$19

  4. #4
    Registered User
    Join Date
    06-03-2021
    Location
    US
    MS-Off Ver
    2016
    Posts
    12

    Re: Conditional Formatting Based on Other Cell

    Attachment 774855

    Here is a picture.

  5. #5
    Registered User
    Join Date
    06-03-2021
    Location
    US
    MS-Off Ver
    2016
    Posts
    12

    Re: Conditional Formatting Based on Other Cell

    NVM- figured it out!

    Next question- is there a way to highlight a row of cells UNTIL one of them is filled in with a value?

    Example (see screenshot, attached): I want Row 51, Columns B:P formatted with a fill color UNTIL one of the cells in that row has a value in it. In this example, the row would remain filled with a background color UNTIL someone marks an 'X' in one of the cells, then the other cells in that row would no longer have a background fill.

    Attachment 774857

  6. #6
    Valued Forum Contributor
    Join Date
    01-07-2022
    Location
    East Asia
    MS-Off Ver
    Office 365
    Posts
    311

    Re: Conditional Formatting Based on Other Cell

    I can't see your attachments, but take a look at the conditional formatting in the attached. It will probably need to be adapted to meet your needs.
    Attached Files Attached Files
    <<< Please click * to thank valued contributors

  7. #7
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016 (preparing to update to 2021)
    Posts
    7,543

    Re: Conditional Formatting Based on Other Cell

    Example (see screenshot, attached):
    Attachment 774857
    This doesn't work !!!
    Attached Files Attached Files

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,540

    Re: Conditional Formatting Based on Other Cell

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
    Ali


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


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite 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. VBA Conditional Formatting based on another Cell
    By pkew22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2021, 12:03 PM
  2. Replies: 2
    Last Post: 09-02-2018, 01:09 PM
  3. [SOLVED] Conditional Formatting based on a cell value
    By kersplash in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2018, 02:14 AM
  4. Replies: 1
    Last Post: 10-04-2016, 05:17 AM
  5. Conditional Formatting via VBA: Change formatting in range based on value of each cell
    By ralphjmedia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 10:37 AM
  6. Replies: 4
    Last Post: 01-06-2012, 05:07 PM
  7. [SOLVED] Conditional formatting based on another cell
    By Shaggyjh in forum Excel General
    Replies: 7
    Last Post: 02-10-2006, 12:10 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