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!
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 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
1 | Location | Potential Need | # Back Ups | |||
2 | 1 | 0 | 1 | |||
3 | 0 | 0 | 1 | |||
4 | 1 | 1 | 0 | |||
5 | 1 | 1 | 1 | |||
6 | 0 | 1 | 0 | |||
7 | 0 | 0 | 0 | |||
Sheet |