Cell F5 contains a number. It will change periodically.
Need to conditionally format cells G29:G86 based on the numbers each contains.
Green; if the number is greater than or equal to F5.
Green; if the number is less than 5% smaller than F5
Yellow; if the number is between 5% and 10% smaller than F5
Red; if the number is more than 10% smaller than F5
So if F5 is 130
A cell containing 135 would be green
A cell containing 129 would be green
A cell containing 121 would be yellow
A cell containing 116 would be red
Thanks in advance...
Bookmarks