Formatting xl cells

[Brian of Basildon]

Does anyone know if xl cells can be programmed to perform "what" or "what
if", "goto", "if", "then" etc

 

[Mike H]

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

 

[Gord Dibben]

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