Formula for Clearing the STATUS box

[conorm]

Is there a way that you can say if cell a1 has any value then clear the status cell? Is it possible to write a formula in the status box?

I imagine it would be a variation of this:

=IF('Bet Angel'!$A$1<>"","????","")

Thanks

[nicrag9]

No you can not write a formula in the status box, when it is updated from betangel that would erase your formula. I think the only way to do what you want is to write some VBA code, so that when the conditions are met, if a certain cell is not empty the code empties the status cell.
if worksheets(your sheet name).range("A1")<>"" then
worksheets("BetAngel").Range("O9")=""
end if

This would clear the status for the first runner if cell A1 was not empty in your own cell. You could put it in a loop to check and clear all the status cells if you need to.

Nic

[conorm]

Thanks a lot Nic I've tried it but can't seem to figure it out? On a similar line is it also possible to use a function to fill multiple cells.

So that I can basically say if a1 is = to anything fill cells b1, c1 and d1 with the same thing?

I just want to have one master trigger that can fill a number of other cells when it is filled and therefore activate another formula?

Thanks

[Bet Angel]

There are example spreadsheets in the spreadsheet area with this coded on them already.

[conorm]

thanks very much, will check it out.