Conditional formating between 2 workbooks.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim Shelton at PDC - 06 Nov 2006 20:44 GMT

I have 2 workbooks.... in workbook #1 I have cells that have conditional
formating to change fill color if the cell value is 1 through 4. I want a
cell in workbook # 2 to change the cell fill color to match the other
workbook. I have a formula in workbook # 2 which must not be changed - So
I was trying to use some other method to get the cell color to change. Like
if cell in work # 1 is green then make cell in work# 2 green - but conditonal
formating will not work with multiple workbooks. Any help would be
appreciated.

Reply to this Message

WesZalewski - 06 Nov 2006 21:16 GMT

make a link to your conditions in workbook 1 somewhere in workbook 2 and
create the same conditional formatting referencing those linked results.

> I have 2 workbooks.... in workbook #1 I have cells that have conditional
> formating to change fill color if the cell value is 1 through 4. I want a
[quoted text clipped - 4 lines]
> formating will not work with multiple workbooks. Any help would be
> appreciated.

Reply to this Message