View Single Post
 
Old 08-26-2011, 05:32 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Am i missing something?
If i copy the data from I19:I31 to range I3:I15, then your range E3:E15 has the same values as the desired range E19:E31.(?!)
The only difference is that in E3:E15, the conditional formatting formulas for the cell colors are not completed, it has only rules 1, 2, 6 and 8 applied from the range B36:B48, the rest of rules you have to write them yourself. Open the conditional formatting, manage rules, and add the other rules...
Reply With Quote