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