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
|
|||
|
|||
Cell Formatting
Is there a way to format a number cell to change to red fonts if less than
another cell? Ex: Cell H2 is 29 which is less than Cell K2 which is 35. I would like to drag a formula down column H to change to red if the value is less than column K. |
#2
|
|||
|
|||
Cell Formatting
Hi,
use conditional formating, highlight the cells, conditional formating, where the formula is enter =H2K2 choose color red "Alicia" wrote: Is there a way to format a number cell to change to red fonts if less than another cell? Ex: Cell H2 is 29 which is less than Cell K2 which is 35. I would like to drag a formula down column H to change to red if the value is less than column K. |
#3
|
|||
|
|||
Cell Formatting
Use Conditional formatting
Select H2 and from menu ..FormatConditional formatting Cell Value Is lessthan =K2 -- Jacob (MVP - Excel) "Alicia" wrote: Is there a way to format a number cell to change to red fonts if less than another cell? Ex: Cell H2 is 29 which is less than Cell K2 which is 35. I would like to drag a formula down column H to change to red if the value is less than column K. |
#4
|
|||
|
|||
Cell Formatting
Thanks, that worked! Now, do you know how I can copy to all cells below? I
tried dragging down the same as I would a formula but it just copied. I'm pretty good with dragging formulas so I'm confident that I'm doing that part correctly. "Eduardo" wrote: Hi, use conditional formating, highlight the cells, conditional formating, where the formula is enter =H2K2 choose color red "Alicia" wrote: Is there a way to format a number cell to change to red fonts if less than another cell? Ex: Cell H2 is 29 which is less than Cell K2 which is 35. I would like to drag a formula down column H to change to red if the value is less than column K. |
#5
|
|||
|
|||
Cell Formatting
On the standard toolbar (excel 2003) there is an icon that looks like a
paintbrush. It's called a format painter. Highlight the cell where it worked, and click on the paintbrush, and "paint" the formatting to the other cells by dragging the brush down. Jim "Alicia" wrote in message ... Thanks, that worked! Now, do you know how I can copy to all cells below? I tried dragging down the same as I would a formula but it just copied. I'm pretty good with dragging formulas so I'm confident that I'm doing that part correctly. "Eduardo" wrote: Hi, use conditional formating, highlight the cells, conditional formating, where the formula is enter =H2K2 choose color red "Alicia" wrote: Is there a way to format a number cell to change to red fonts if less than another cell? Ex: Cell H2 is 29 which is less than Cell K2 which is 35. I would like to drag a formula down column H to change to red if the value is less than column K. |
#6
|
|||
|
|||
Cell Formatting
Make sure Excel has not "helped" you by adding $ signs to the formula.
Gord Dibben MS Excel MVP On Thu, 13 May 2010 10:20:05 -0700, Alicia wrote: Thanks, that worked! Now, do you know how I can copy to all cells below? I tried dragging down the same as I would a formula but it just copied. I'm pretty good with dragging formulas so I'm confident that I'm doing that part correctly. "Eduardo" wrote: Hi, use conditional formating, highlight the cells, conditional formating, where the formula is enter =H2K2 choose color red "Alicia" wrote: Is there a way to format a number cell to change to red fonts if less than another cell? Ex: Cell H2 is 29 which is less than Cell K2 which is 35. I would like to drag a formula down column H to change to red if the value is less than column K. |
Thread Tools | |
Display Modes | |
|
|