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.
<tbody>
</tbody>
1 | A | B | C | D | E | F | G | H |
2 | PriorFcst | Fcst | Budget | B/(W) PFcst | B/(W) Budget | R, Y, G | ||
3 | Direct Labor | 10 | 5 | 7 | 5 | -2 | -8.21695 | |
4 | Indirect Labor | |||||||
5 | Fringes | |||||||
6 | Total Labor |
<tbody>
</tbody>