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

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

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