Mix of Knowledge
IT & Life thoughts by... Mohamed Faramawy
Link to another workbook using conditional formatting in Excel
Lets call the workbook where you want to enter the conditional format as MyWbk and the other one SrcWbk. This instructions are for excel 2007. Your mileage may vary.
Open both Workbooks
In MyWbk go to the Formulas Menu, and select Define Name
Enter in Name > testname
In the "Refers to" field, select click on the range selector (at right) and when the selector opens, select SrcWkb and then the cell you want as source for the format condition.
Accept the name creation
Go to the cell where you want to enter the conditional format
Select the Home Menu / Conditional Formatting / Manage Rules
Enter New Rule
Select "Use a formula to determine which cells to format"
Enter the formula you want, using the defined name. For example =IF(testname=1,TRUE)
Select the desired formatting
Test the formula changing the value in SrcWbk
You are done!
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)