| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to return formatting to cells rather than value for "IF" cmnd
Can formatting of cells be returned after an "IF" logic formula rather than a
value? I'd like to have cells be colored when a specified cell has a specific number entered in it when the "IF" statement is true and not colored when the "IF" statement is false. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to return formatting to cells rather than value for "IF" cmnd
Look up conditional formatting in help
-- Regards, Peo Sjoblom "nbspacenut" wrote in message ... Can formatting of cells be returned after an "IF" logic formula rather than a value? I'd like to have cells be colored when a specified cell has a specific number entered in it when the "IF" statement is true and not colored when the "IF" statement is false. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to return formatting to cells rather than value for "IF" cmnd
Say you want B2 to be blue if A1 is =5
For the Conditional Format formula for B1, use the drop down box to Formula Is =A1=5, then choose your format (blue in this case). -- John C "nbspacenut" wrote: Can formatting of cells be returned after an "IF" logic formula rather than a value? I'd like to have cells be colored when a specified cell has a specific number entered in it when the "IF" statement is true and not colored when the "IF" statement is false. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF cells(row,column) contain "this word" ??? Then return text | New Users to Excel | |||
| function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| If (A1 = "ValueA" & C1 = "ValueB") return the quantity of matches | Excel Discussion (Misc queries) | |||
| Search a random array of cells and return a value of "X" | Excel Worksheet Functions | |||
Hybrid Mode
