Conditional Formatting Shift Schedule

Question

Hi

I need to provide a shift schedule for all the employees in our business. It is supposed to be a simple table with names on the left and time on the top.

	A	B	C	D	E	F	G	H
1		7:00 AM	8:00 AM	9:00 AM	10:00 AM	11:00 AM	12:00 PM	1:00 PM
2
3	Name		b				e

(Note: A-H and 1-3 are just to show columns and rows.)

I'd like to have a conditional formatting that colors all the cells from b (beginning) to e (end), in this example all cells from C3 to G3.

Unfortunately I do not know a formula to use. The idea is that I can type in b and e and it automatically colors the shift.

Thanks for any help I can get.

Answer 1

Hi,

Click on cell B3 and go to Home > Conditional formatting > New Rule > Use a formula to determine which cells to format.  In the Formula bar there, enter this formula

=AND(COUNTIF($A3:B3,"b")>0,COUNTIF($A3:A3,"e")=0)

Click on Format > Fill > Yellow  > OK/Apply.  Now copy the formatting from this cell to the right/down

Hope this helps.

Answer 2

You are welcome.

Answer 3

Hey,

Awesome, works just fine.

Thanks a lot.