Help with VBA

[brian]

I originally posted this on the worksheet functions board
but I was told that I need VBA.

Can someone help me with this

.. This is
what I'm trying to do-

I have 2 different workbooks.
Workbook 1 is a construction status
When a 1 of the 5 stages of const. is completed an X is
placed in the cell.
Workbook 2 has amounts of the construction loan for each
stage.

I am looking for a formula that when the X is placed in
the cell in workbook 1 for each stage of construction
the corresponding cell with the amount of $ for the loan
in workbook 2 turns yellow. So when the project is
complete all 5 cells on workbook 2 should be yellow.

So to sum it all up I want a formula that will change
the color of a certain cell in workbook 2 when an X is
typed
in a cell in workbook 1.

Thanks Again for your help.
Brian

 

[Trevor Shuttleworth]

Brian

you can do this with conditional formatting but you have to fudge it a
little

Assume that you want to put the "x" in column B on worksheet 1. First,
select column B and give it a name, for example, "XRange" (no quotes)

Then, in the column with the values on Worksheet 2 you need to set up the
conditional formatting:

Formula is: =OFFSET(XRange,ROW()-1,,1)="x"
and choose a suitable highlighter format.

Note that for this to work, the codes and values and "x"'s will all need to
line up, for example

Worksheet 1:
A3 = a
B3 = x

Worksheet 2
A3 = a
B3 = 4000 <= this cell has the conditional formatting

will highlight the value in cell B3

Regards

Trevor