Perhaps instead of (b:8)+2 you intended to say B$8+2% ?
If so, in your CF condition, choose cell value greater than or equal, then
for the value put =B$8+2% (remember the = sign).
--
David Biddulph


"Whitney" wrote in message
...
I would like to set up CF to change the font color to red if the value
(b2:b7) is = or greater than the cell reference (b:8)+2. What is the
formula?
Ex. only B7 would change to red font.

A B
1Chart Dates 101 OR - Place Orders
2Mon 2/15 12.75%
3Tues 2/16 15.40%
4Wed 2/17 16.23%
5Thurs 2/18 14.11%
6Fri 2/19 15.48%
7Sat 2/20 23.01%

8Average 16.16%