Forum Discussion
Conditional formatting based on a field below
Hi, I have the following table: Each actual value is relating to the "Planned" value below. I would like each "Actual" value to have a red colour if the planned value is 0 or green if the n...
Hi
I think this might be what you want? This uses conditional formatting and might help you?
BTW - is there any reason why you have to layout with actual above planned? If you have actual next to planned (as shown on the right hand side) that it is easier to understand and the formatting also is simpler.
hope this helps.
Peter
- You and I think alike. I made the same recommendation: change to side-by-side!
