Need CF Help

[Phil Hageman]

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

 

[Tom Ogilvy]

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.