+ Reply to Thread
Results 1 to 4 of 4

Can I use 1 conditional format to affect multiple cells based on values in others?

  1. #1
    Registered User
    Join Date
    12-14-2013
    Location
    United Kingdom
    MS-Off Ver
    Home & Student 2013
    Posts
    25

    Can I use 1 conditional format to affect multiple cells based on values in others?

    To really simplify my problem lets put in column A YES YES NO YES. In column B Mike Sarah Paul Jane.

    Is it possible to use a conditional format on cells B1:B4 to be green if cell A1:A4 = YES? So in the above example Mike, Sarah and jane would be in green text/fill but Paul would stay base colours.

    I know I could set a format for each individual B column cell, but I have a very long list. This is just a simple example of what I want to achieve.

    Edit:
    An alternative would be to have "YES" in C1 then condition format 'If A1 = $C$1 then B1 is green. If A2 =$C$1 then A2 is green, and so on.
    Last edited by Funky Gibbon; 11-20-2019 at 01:23 PM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,759

    Re: Can I use 1 conditional format to affect multiple cells based on values in others?

    The Answer is yes.

    Select the range that you want the conditional format to apply.

    In your case B1 to B4

    Write your formula as if you were only writing it for the first cell in your range so

    =IF(A1="Yes",1,0)

    Excel will handle the complexities for you.
    Last edited by mehmetcik; 11-20-2019 at 01:36 PM.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Registered User
    Join Date
    12-14-2013
    Location
    United Kingdom
    MS-Off Ver
    Home & Student 2013
    Posts
    25

    Re: Can I use 1 conditional format to affect multiple cells based on values in others?

    Thank you for the reply and whilst I am grateful for your time, it doesn't really help my problem. Maybe you took my question literally as 'Can I?'
    If I changed it to 'How do i ....?' would you be able to explain, in simple terms please.
    I'm guessing I select the 'Use a formula to determine which cells'. I've tried setting the formula in cell B1 which works fine but then how do I expand it to cover B1:B4?
    Last edited by Funky Gibbon; 11-20-2019 at 01:43 PM.

  4. #4
    Registered User
    Join Date
    12-14-2013
    Location
    United Kingdom
    MS-Off Ver
    Home & Student 2013
    Posts
    25

    Re: Can I use 1 conditional format to affect multiple cells based on values in others?

    Thank you very much. This is exactly what I wanted.

+ Reply to Thread

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