Fill in RED
Fill in Green
I need some help with the above code. I use these formula in conditional formating.
Basically what it does, Value in B4 is the number of person working at a specific date. This specific date is in A4.
Color Fill cell B4 in RED when below minimum staff
Color Fill cell B4 in Green when Equal or above minimum staff
Minimum staff may differ if the specific date is during weekend.
My question :
I would like to apply this formula on cell B4 to B34 where the specific date is always on the same line. So B30 should use A30 as specific date.
I'm sure there is a way to do this, I'm just not there yet.
Thank in advance for you help.
Code:
=OR(AND(B4<4,WEEKDAY(A4,2)>5),AND(B4<6,WEEKDAY(A4,2)<6))
Code:
=OR(AND(B4>3,WEEKDAY(A4,2)>5),AND(B4>5,WEEKDAY(A4,2)<6))
I need some help with the above code. I use these formula in conditional formating.
Basically what it does, Value in B4 is the number of person working at a specific date. This specific date is in A4.
Color Fill cell B4 in RED when below minimum staff
Color Fill cell B4 in Green when Equal or above minimum staff
Minimum staff may differ if the specific date is during weekend.
My question :
I would like to apply this formula on cell B4 to B34 where the specific date is always on the same line. So B30 should use A30 as specific date.
I'm sure there is a way to do this, I'm just not there yet.
Thank in advance for you help.