I need to be able to use conditional format to do the following:
Example:
A2 is 90%
B2 is 70%
C2 is 96%
B2 is more than 5% BELOW A2 so the cell turns red
C2 is more than 5% ABOVE A2, so the cell turns green
For some reason (maybe because it is after 6:00 on Friday night) I can't get my brain around this.
Thanks for your help!)
Bookmarks