# Conditional Formatting Help

#### M3rlin

##### New Member
Hi All,
I need some help to create a conditional format that when applied to each cell in column B covers all conditions shown below (in columns C & D as well)as I have manually illustrated (green, yellow, red cell shading). The conditional format in each cell would only be conditional for the information from the same row in columns B, C, & D. I am thinking that a conditional formula can be used, although I can not figure it out. Thanks!
Staffing Tracker - BaltWash.xls
BCDE
1LocationPotential Need# Back Ups
2101
3001
4110
5111
6010
7000
Sheet

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

#### Norie

##### Well-known Member
What are the actual conditions?

#### M3rlin

##### New Member
#1: Green if B1=1, C1=0, D1=1
#2: Yellow if B1=0, C1=0, D1=1
#3: Yellow if B1=1, C1=1, D1=0
#4: Yellow if B1=1, C1=1, D1=1
#5: Red if B1=0, C1=1, D1=0
#6: Red if B1=0, C1=0, D1=0

I have all of these conditions displayed in my html post. Thanks

##### Well-known Member
Hello,

Enter this for the first cell and paste the formats to other cells.

Condition 1

Formula is =AND(\$A2=1,\$B2=0,\$C2=1) (FORMAT AS GREEN)

Condition 2

Formula is =OR(AND(\$A2=0,\$B2=0),AND(\$A2=1,\$B2=1)), (FORMAT AS YELLOW)

Condition 3

Formula is =AND(\$A2=0,\$C2=0) (FORMAT AS RED)

I hope I've copied those correctly!

Just out o curiosity what happens if the cells contain

0 1 1 and
1 0 0

#### M3rlin

##### New Member
Thanks for the help! I had to move the 3rd condition (Red shading) to number 2. After I did that, the formulas were perfect!

To answer your question, there will never be a 0, 1, 0 for the data I am gathering and if there is a 1, 0, 0 then there is a conditional format to shade the backup column red.

##### Well-known Member
Thats OK.

I actually have got the RED condition as the 2nd one, I thought i was being clever by putting them in the same order as your sample data.

That will teach me to check it!!

Replies
42
Views
409
Replies
2
Views
272
Replies
7
Views
198
Replies
8
Views
275
Replies
1
Views
113

1,195,665
Messages
6,011,029
Members
441,580
Latest member
BornholmerBjarne

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back