Formatting xl cells

  • Thread starter Thread starter Brian of Basildon
  • Start date Start date
B

Brian of Basildon

Does anyone know if xl cells can be programmed to perform "what" or "what
if", "goto", "if", "then" etc
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Google Pixel 2 and Pixel 2 XL 2
Android Q Beta Is Live! 4
Google Pixel 2 and Pixel XL 2 10
insert 780 into phone list XL workbook 1
Excel TWO Instances of Excel One watching Other 3
Colors according to the month 3
how to insert rows inbetween rows of data ? 1
how do i create a divisible formula 3

Back
Top