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

1. ## 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.

2. ## 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.

3. ## 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?

4. ## 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.

##### Users Browsing this Thread

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

#### 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