I must be stating this problem wrong - seems like there
should be a way to code this:

Sheet1 Sheet2
target cell source cell
AI17 linked to B30 (CF: font & background)
AI20 linked to B62 (CF: font & background)
AI23 linked to B94 (CF: font & background)

Sheet1 Sheet3
target cell source cell
AI35 linked to B30 (CF: font & background)
AI38 linked to B62 (CF: font & background)
AI41 linked to B94 (CF: font & background)

On sheets 2 and 3 (source), the "B" cells have three
conditional formats which result in: font color = white
(or black), bold; and a background color of green, yellow,
or red. There is a sheet 4 and 5 with the same
source/target setup.

What I need is for the linked cells in Sheet1 (target) to
show the same fonts and backgrounds as the cells in sheets
2 and 3 - as they change in response to the true/false
properties of the conditional formulas in the source
sheets. For example, if sheet2/B30 is green background,
bold white font, sheet1/AI17 would be the same - the data
and colors would appear the same on sheet1 as on sheet2,
where they originate. However, if sheet2/B30 changes in
sheet2, those same changes would appear on sheet1.

I would like to put coding in the workbook module to
accopmlish this task.

Any help would be sincerely appreciated.

Thanks,
Phil

You would need to conditionally format the cells in Sheet1 the same as you
have in the other sheets.

You can't programmatically detect formatting imposed on a cell - you would
have to check the condition that is contained in the conditional formatting
rules. This would be significanlty more work than just conditionally
formatting the cells in sheet1.

--
Regards,
Tom Ogilvy

Phil Hageman wrote in message
...
I must be stating this problem wrong - seems like there
should be a way to code this:

Sheet1 Sheet2
target cell source cell
AI17 linked to B30 (CF: font & background)
AI20 linked to B62 (CF: font & background)
AI23 linked to B94 (CF: font & background)

Sheet1 Sheet3
target cell source cell
AI35 linked to B30 (CF: font & background)
AI38 linked to B62 (CF: font & background)
AI41 linked to B94 (CF: font & background)

On sheets 2 and 3 (source), the "B" cells have three
conditional formats which result in: font color = white
(or black), bold; and a background color of green, yellow,
or red. There is a sheet 4 and 5 with the same
source/target setup.

What I need is for the linked cells in Sheet1 (target) to
show the same fonts and backgrounds as the cells in sheets
2 and 3 - as they change in response to the true/false
properties of the conditional formulas in the source
sheets. For example, if sheet2/B30 is green background,
bold white font, sheet1/AI17 would be the same - the data
and colors would appear the same on sheet1 as on sheet2,
where they originate. However, if sheet2/B30 changes in
sheet2, those same changes would appear on sheet1.

I would like to put coding in the workbook module to
accopmlish this task.

Any help would be sincerely appreciated.

Thanks,
Phil