Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF
I hve a formula in a cell. Is it possible that I format the cell in such a
way that if the value comes to 5, the background color changes automatically? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF
You can do this with conditional formatting. How to do it depends on what
version of Excel you're using. For versions prior to Excel 2007: Select the cell in question. Let's assume this is cell A1 Goto the menu FormatConditional Formatting Select Formula Is Enter this formula in the box on the right: =AND(ISNUMBER(A1),A15) Click the Format button Select the Patterns tab Select the desired fill color OK your way out -- Biff Microsoft Excel MVP "Malik" wrote in message ... I hve a formula in a cell. Is it possible that I format the cell in such a way that if the value comes to 5, the background color changes automatically? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF
thx valco,
really appreciate ur help. what if the cell colour to be formatted (a1 in ur ex) is text dependent? "T. Valko" wrote: You can do this with conditional formatting. How to do it depends on what version of Excel you're using. For versions prior to Excel 2007: Select the cell in question. Let's assume this is cell A1 Goto the menu FormatConditional Formatting Select Formula Is Enter this formula in the box on the right: =AND(ISNUMBER(A1),A15) Click the Format button Select the Patterns tab Select the desired fill color OK your way out -- Biff Microsoft Excel MVP "Malik" wrote in message ... I hve a formula in a cell. Is it possible that I format the cell in such a way that if the value comes to 5, the background color changes automatically? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF
Then you use a different formula.
=A1="text" Where "text" is the string you want to test for. For example: =A1="apples" Or, if you want to compare 2 cells: B1 = apples Then: =AND(A1<"",B1<"",A1=B1) -- Biff Microsoft Excel MVP "Malik" wrote in message ... thx valco, really appreciate ur help. what if the cell colour to be formatted (a1 in ur ex) is text dependent? "T. Valko" wrote: You can do this with conditional formatting. How to do it depends on what version of Excel you're using. For versions prior to Excel 2007: Select the cell in question. Let's assume this is cell A1 Goto the menu FormatConditional Formatting Select Formula Is Enter this formula in the box on the right: =AND(ISNUMBER(A1),A15) Click the Format button Select the Patterns tab Select the desired fill color OK your way out -- Biff Microsoft Excel MVP "Malik" wrote in message ... I hve a formula in a cell. Is it possible that I format the cell in such a way that if the value comes to 5, the background color changes automatically? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|