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
|
|||
|
|||
Formatting xl cells
Does anyone know if xl cells can be programmed to perform "what" or "what
if", "goto", "if", "then" etc -- Brian of Basildon |
#2
|
|||
|
|||
Formatting xl cells
Hi,
You can almost certainly do that in Excel, probably with a formula (but the goto bit maybe a problem) and if not with a macro. Why not post what you are trying to achieve and I'm sure someone will help. Mike "Brian of Basildon" wrote: Does anyone know if xl cells can be programmed to perform "what" or "what if", "goto", "if", "then" etc -- Brian of Basildon |
#3
|
|||
|
|||
Formatting xl cells
You cannot "format" cells to do anything.
You would need formulas in those cells to return results based upon your criteria. In B1 enter =IF(A1="qwerty", "A1 is qwerty","A1 is not qwerty") Which is an if, then,else formula. Speaking of formulas, they can return results only to the cells in which they are written. i.e. a formula can "pull" but it cannot "push" Gord Dibben MS Excel MVP On Sun, 31 Aug 2008 03:55:00 -0700, Brian of Basildon wrote: Does anyone know if xl cells can be programmed to perform "what" or "what if", "goto", "if", "then" etc |
Thread Tools | |
Display Modes | |
|
|