Hi all,
I am having an issue with a conditional formula that is based on a formula.
What I am trying to achieve, is that if a growth rate calculation in a cell matches the value of a specific cell, then the growth rate calculation should be shaded a specific color.
For some reason, this calculation is not working for some cells in my workbook. I have confirmed that the calculation and the reference cell DO match.
I have confirmed that the cell the formatting is applied to corresponds ONLY to that cell, not a range of cells.
I am really stumped at why this might not be working. Any thoughts or suggestions would be very helpful....I would post a sample file if I could.