Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"if" statment in excell cell that will change format in another
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"if" statment in excell cell that will change format in another
On Tue, 1 Aug 2006 23:45:01 -0700, Paul wrote:
Not possible. Worksheet functions can only return values and only to the cell in which they are located. You could change some of the format options in one cell based on the contents of another cell by using Conditional Formatting in the "target" cell. Post back with more information if this hint doesn't point you in the correct direction. --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"if" statment in excell cell that will change format in anothe
Thanks. will give this a go
"Ron Rosenfeld" wrote: On Tue, 1 Aug 2006 23:45:01 -0700, Paul wrote: Not possible. Worksheet functions can only return values and only to the cell in which they are located. You could change some of the format options in one cell based on the contents of another cell by using Conditional Formatting in the "target" cell. Post back with more information if this hint doesn't point you in the correct direction. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Change the format of the cell | Excel Discussion (Misc queries) | |||
Format of a cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
notification by email by cell format change | Excel Worksheet Functions |