if help

[mattG]

I want to insert a formula to make the following and need
help...please...

I have an if formula where I want the format of a cell to be changed,
color, border stuff like that to be more noticable if there is a value
in a cell two cells to the right of it. Also I want that same cell
that chenges format to have another cell referance pop up in it. So
my specific example is as follows.

Cell A5 =fixture #
Cell C5 = Fixture Type
Cell A2 = Sheet fixture Type

If cell A5 has a number in it (Must be able to be any number) I want
Cell C5 to have the contents of A2 appear and the cell to change
formatting in some way.

Is this possible?

Thanks for any help.

Matt

 

[mattG]

I want to insert a formula to make the following and need
help...please...

I have an if formula where I want the format of a cell to be changed,
color, border stuff like that to be more noticable if there is a value
in a cell two cells to the right of it. Also I want that same cell
that chenges format to have another cell referance pop up in it. So
my specific example is as follows.

Cell A5 =fixture #
Cell C5 = Fixture Type
Cell A2 = Sheet fixture Type

If cell A5 has a number in it (Must be able to be any number) I want
Cell C5 to have the contents of A2 appear and the cell to change
formatting in some way.

Is this possible?

Thanks for any help.

Matt

TO ADD A LITTLE MORE FUN TO THE PROBLEM

I HAVE A FORMULA IN CELL B5 THAT IS COPIED ALL THE WAY DOWN THAT B
COLUMN

I ONLY WANT B TO APPEAR IF THERE IS SOMETHING IN COLUMN A

THANKS,
MATT

 

[Peter Duniho]

I want to insert a formula to make the following and need
help...please...

Could clarify what part of your question involves C# or .NET? As near
as I can tell, it's purely a spreadsheet question (Excel?).

If your question isn't a C# question, you should probably find a more
appropriate newsgroup rather than expecting an answer here.

Pete