Growing CF Problem
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 |
All times are GMT +1. The time now is 07:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com