Hi Phil,
Presumably you would use the same conditional formatting formulas
you used on your other sheets. You do not provide much to go on.

You might take a look at
Conditional Formatting,
http://www.mvps.org/dmcritchie/excel/condfmt.htm
and when you need more than 3 conditions using an Event macro
http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Phil Hageman" wrote in message ...
Sheet1 Sheet2 Sheet3
AI17 B30
AI20 B62
AI23 B94
AI35 B30
AI38 B62
AI41 B94

How do I get the conditional formats for cells in sheet2
and sheet3 to carry over to the cells in sheet1? Would I
use a formula in sheet1 conditional formatting (only three
conditions), or VBA code in the workbook module? There
are four worksheets rolling up into sheet one, so this
example is only part of the overall issue to be resolved.

Could someone help me with the formula/code?

Thanks,
Phil