Gradient Conditional Formula across several cells

[Newbienew]

This is kind of a piggy back to another forum "Adding Up Several Percentages". Basically I have a row of x's 98 cells out. With those 98 cells I want to try and get a gradient stretch across all cells at the same time. So if all 98 cells are not filled with an X i would like a percentage of it to be displayed red yellow green. Is this possible?

[TABLE="width: 276"]
<tbody>[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

<tbody>

<colgroup><col style="mso-width-source:userset;mso-width-alt:768; width:17pt" width="23" span="12"> </colgroup><tbody>
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl65, width: 23"] [/TD]
[TD="class: xl66, width: 23"] [/TD]

[TD="class: xl67"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl71"] [/TD]
[TD="class: xl72"] [/TD]
[TD="class: xl73"] [/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl75"] [/TD]
[TD="class: xl66"] [/TD]

</tbody>

</tbody>

 

[Gerald Higgins]

Not sure what you mean exactly but perhaps consider merging the cells containing the Conditional Formating, into one large single cell ?