conditional formatting = or > cell reference + 2

W

Whitney

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

Bernard Liengme

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
 
D

David Biddulph

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top