matt.mitchell
New Member
- Joined
- Jul 18, 2012
- Messages
- 1
I've seen several threads on conditional formatting using traffic lights, but haven't seen how to include row labels with the traffic lights. Here is a snapshot of what I'm trying to accomplish. The formula in the R, Y, G is IF(X29>=0.00000000001,1,IF(F3<0,F3/-C3,IFERROR(F3/C3,-500))) and my formula in B3 is =IF(H3<-0.05,0,IF(H3<0,1,2)) where 0 is red, 1 is yellow, 2 is green. The conditional format applied to column H is Green = value >0; Red is a value <-0.05 and Yellow is between -0.05 and 0. The question is, How do I include the traffic light in Column B with the label in the same row? In this case, I'm looking for a red traffic light with the label Direct Labor in cell B2.[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]PriorFcst[/TD]
[TD]Fcst[/TD]
[TD]Budget[/TD]
[TD]B/(W) PFcst[/TD]
[TD]B/(W) Budget[/TD]
[TD]R, Y, G[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Direct Labor[/TD]
[TD][/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]-2[/TD]
[TD]-8.21695[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Indirect Labor[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Fringes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Total Labor[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]PriorFcst[/TD]
[TD]Fcst[/TD]
[TD]Budget[/TD]
[TD]B/(W) PFcst[/TD]
[TD]B/(W) Budget[/TD]
[TD]R, Y, G[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Direct Labor[/TD]
[TD][/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]-2[/TD]
[TD]-8.21695[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Indirect Labor[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Fringes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Total Labor[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]