Conditional formatting

[JONNEWBY]

so i tried conditional formatting in excel and it works but just for one cell that contains the specified criteria. is there a way i can get the whole row a specific fill color?

-jonnewby

 

[phxsportz]

Easy, what is the criteria for the conditional formatting, and what is the range of hte row you want it applied to ?

 

[phxsportz]

Here's an example

<b>Sheet4</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:108px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="color:#ffffff; background-color:#ff0000; font-weight:bold; ">Make this Row</td><td style="color:#ffffff; background-color:#ff0000; font-weight:bold; ">RED</td><td style="color:#ffffff; background-color:#ff0000; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#ff0000; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#ff0000; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#ff0000; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#ff0000; font-weight:bold; ">STOP</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="color:#ffffff; background-color:#0000ff; font-weight:bold; ">Make this Row</td><td style="color:#ffffff; background-color:#0000ff; font-weight:bold; ">Blue</td><td style="color:#ffffff; background-color:#0000ff; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#0000ff; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#0000ff; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#0000ff; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#0000ff; font-weight:bold; ">STOP</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="color:#ffffff; background-color:#008000; font-weight:bold; ">Make this Row</td><td style="color:#ffffff; background-color:#008000; font-weight:bold; ">Green</td><td style="color:#ffffff; background-color:#008000; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#008000; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#008000; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#008000; font-weight:bold; "> </td><td style="color:#ffffff; background-color:#008000; font-weight:bold; ">STOP</td></tr></table>