Conditional Formatting

Giganews Newsgroups
Subject: Conditional Formatting
Posted by:  bodhisatvaofboogie
Date: Thu, 18 May 2006

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($K1>=13,$K1<=98),$K1>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!!!

Replies