software

I want to highlight a specific amount of cells in a row based on what one
cell in the row reads. If J9 gt;= 100% then cells B9 thru J9 will be
highlighted blue. Please, all help is gretly appreciated. thank you.

Hi Jeff,

Select Columns B:J if this is for all rows, or
Select B9:J9 if this is only for row 9

Formula1: =$J9gt;1 format, patterns, blue

More information on Conditional Formatting at
www.mvps.org/dmcritchie/excel/condmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;jeffquot; gt; wrote...
gt; I want to highlight a specific amount of cells in a row based on what one
gt; cell in the row reads. If J9 gt;= 100% then cells B9 thru J9 will be
gt; highlighted blue. Please, all help is gretly appreciated. thank you.
Thank you. That worked flawlessly. I wish you could see this spread from a
first timer. It's bad a$$.

quot;David McRitchiequot; wrote:

gt; Hi Jeff,
gt;
gt; Select Columns B:J if this is for all rows, or
gt; Select B9:J9 if this is only for row 9
gt;
gt; Formula1: =$J9gt;1 format, patterns, blue
gt;
gt; More information on Conditional Formatting at
gt; www.mvps.org/dmcritchie/excel/condmt.htm
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;jeffquot; gt; wrote...
gt; gt; I want to highlight a specific amount of cells in a row based on what one
gt; gt; cell in the row reads. If J9 gt;= 100% then cells B9 thru J9 will be
gt; gt; highlighted blue. Please, all help is gretly appreciated. thank you.
gt;
gt;
gt;

You're welcome, though covered on my condfmt.htm the
directions could have be a little more clear, Should have included
that the formula is based on the address of the active cell. So
for what I supplied, you would have to at least be on Row 9 to use
that formula because if refers to cell $J9

quot;jeffquot; gt; wrote ...
gt; Thank you. That worked flawlessly. I wish you could see this spread from a
gt; first timer. It's bad a$$.
gt;
gt; quot;David McRitchiequot; wrote:
gt;
gt; gt; Hi Jeff,
gt; gt;
gt; gt; Select Columns B:J if this is for all rows, or
gt; gt; Select B9:J9 if this is only for row 9
gt; gt;
gt; gt; Formula1: =$J9gt;1 format, patterns, blue
gt; gt;
gt; gt; More information on Conditional Formatting at
gt; gt; www.mvps.org/dmcritchie/excel/condmt.htm
gt; gt; ---
gt; gt; HTH,
gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt;
gt; gt; quot;jeffquot; gt; wrote...
gt; gt; gt; I want to highlight a specific amount of cells in a row based on what one
gt; gt; gt; cell in the row reads. If J9 gt;= 100% then cells B9 thru J9 will be
gt; gt; gt; highlighted blue. Please, all help is gretly appreciated. thank you.
gt; gt;
gt; gt;
gt; gt;