Select the entire sheet (A1 active), then apply CF using Formula Is: =AND($B1>5,$C2>60,$D2>60) Format to taste, ok out The above will format entire rows satisfying the 3 conditions in cols B to D (Attendance, Math & History) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Syahira" wrote: I have a file where I want to use conditional format to tell whether

You are getting your $'s in the wrong place. Edit the cell, click on say each range C3:C118, then use F4 to toggle through the various $ options Steve On Fri, 28 Jul 2006 03:48:01 +0100, Syahira <Syahira@discussions.microsoft.com> wrote: Let say I have this formula, =SUMIF('TSJ Student List'!C3:C118,"=4",'TSJ Student List'!A3:A118) My question is how can I use only rows

=SUMIF([workbook1]A!C:C;A2;[workbook1]A!B:B) Syahira skrev: What if it is a different workbook? "Fingerjob" wrote: Or(assume the same placement as MAX) Write in B2 sheet B =SUMIF(B!C:C;A2;B!B:B) Copy down as far as required Best regards Petter Bøhler Max skrev: One way is via INDEX / MATCH ..

=SUMIF(A!C:C;A2;A!B:B) I think this will work better . :-) Fingerjob skrev: Or(assume the same placement as MAX) Write in B2 sheet B =SUMIF(B!C:C;A2;B!B:B) Copy down as far as required Best regards Petter Bøhler Max skrev: One way is via INDEX / MATCH .. Assuming the source table below is in sheet: A, within A1:C5 Branch