Conditional Formating Questions
Posted by Glenn Balian on January 29, 2002 2:21 PM
I'm fine with conditional formatting for the cell that calculates the data. For this cell I can use the "cell value" option. However, I want to have another cell in the summary portion of the report with the same color as the cell with the calculation.
For the linked cell, I want to turn a wingding "L" (a circle) the same color as the calculated cell. I'm working with three colors. Here are the contraints:
Calculated variance is Less than -20% or Greater than +20% (code red); Variance is -10% to -20% OR +10% to +20% (code yellow); Variance is between -10% and +10%.
Again the cell value constraints allow me to get the job done for the calculated cell. I can't accomplish this with the "formula is" choices. The key problem is that Excel won't take "-.2<C53<-1 or .1<C53<.2" for the yellow option.
The other idea is being able to have the referred cell simply change colors with the conditionally formatted calculation cell. I haven't found out how to make this link happen.