Is This Possible - without VBA?

[Da~One]

In cell A1 of a spreadsheet I have a number: X that can change to anything.

In row B spanning about 100 columns each cell contains either a 1 or a 0.

In row C, I want to be able to do the following:

If the column in B that matches the current column in C MINUS X number of
columns (the number in A1) is 1, do something.

EG:::
X (value in A1) = 5

Cell is C10
If B10 - 5 (which is cell B5) is 1, do something

Another EG:::
X (value in A1) = 7

Cell is C10
If B10 - 7 (which is cell B3) is 1, do something....

Is this possible at all WITHOUT using VBA?

 

[J.E. McGimpsey]

the first part is easy:


C10: =IF(OFFSET(B10,-A1,0)=1,"<do something>", "")

the second part, <do something> is harder - worksheet functions can
only return values to their calling cells - they can't "do" anything
like change formatting, change the value of other cells, change
environment settings, etc. For one of those types of things, you'd
need to use VBA.