If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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% |
#2
|
|||
|
|||
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% |
#3
|
|||
|
|||
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% |
Thread Tools | |
Display Modes | |
|
|