conditional formatting = or cell reference + 2
 

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%

conditional formatting = or cell reference + 2
 

This is what I have in column B
Numbers
5
6
12
24
9
26
18
100
120
I selected B2:B10 and used this for the conditional format formula =B2=B4
That gave a red font to the 12 and the last two numbers - the last two get
compared to blank cells
Modified the formula to =AND(B2=B4,B4<"")
Now only the 12 is red
Note the formula uses B2 and B4 because B2 is the first cell in the range
that I selected to apply conditional formatting.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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%

conditional formatting = or cell reference + 2
 

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%