close

These formulas work WONDERFUL, thanks to one of you who was kind enough to
help me out with them. I want to use them to do one more thing, and I'm not
sure how to adjust it. These select the ENTIRE row for bold or highlighting.
I wish to have them select the row, but only from Column A through X.

=OR(AND($K1gt;=13,$K1lt;=98),$K1gt;100)

and

=AND($K1=99,$V1=0)

Currently when this funciton goes, it tacks on a bunch of extra empty
columns, making it not printer friendly. I figured there must be a way to
have it only do the range I want, and not add any extra columns. THANKS!!!It looks like the conditional formating is applied to those extra columns.
You can remove it by selecting the columns that don't need to be highlighted
and use the delete button on Format-gt;Conditional formating.

Hope this helps,
Miguel.

quot;bodhisatvaofboogiequot; wrote:

gt; These formulas work WONDERFUL, thanks to one of you who was kind enough to
gt; help me out with them. I want to use them to do one more thing, and I'm not
gt; sure how to adjust it. These select the ENTIRE row for bold or highlighting.
gt; I wish to have them select the row, but only from Column A through X.
gt;
gt; =OR(AND($K1gt;=13,$K1lt;=98),$K1gt;100)
gt;
gt; and
gt;
gt; =AND($K1=99,$V1=0)
gt;
gt; Currently when this funciton goes, it tacks on a bunch of extra empty
gt; columns, making it not printer friendly. I figured there must be a way to
gt; have it only do the range I want, and not add any extra columns. THANKS!!!
gt;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()