Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with VBA
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 "brian" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|