Prev: Data table with inputs from a differente worksheet
Next: Disable macro selections under tools menu
From: Whitney on 19 Apr 2010 14:45
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%

From: Bernard Liengme on 19 Apr 2010 15:10
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" <Whitney(a)discussions.microsoft.com> wrote in message
news:4B729908-F997-4820-8905-78824C1C199C(a)microsoft.com...
> 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%
>
From: "David Biddulph" groups [at] on 19 Apr 2010 15:10
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" <Whitney(a)discussions.microsoft.com> wrote in message
news:4B729908-F997-4820-8905-78824C1C199C(a)microsoft.com...
> 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%
>

 | 
Pages: 1
Prev: Data table with inputs from a differente worksheet
Next: Disable macro selections under tools menu