conditional formating a specific amount of cells in a row.
 

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

conditional formating a specific amount of cells in a row.
 

Hi Jeff,

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

Formula1: =$J91 format, patterns, blue

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

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

conditional formating a specific amount of cells in a row.
 

Thank you. That worked flawlessly. I wish you could see this spread from a
first timer. It's bad a$$.

"David McRitchie" wrote:

Hi Jeff,

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

Formula1: =$J91 format, patterns, blue

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

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

conditional formating a specific amount of cells in a row.
 

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

"jeff" wrote ...
Thank you. That worked flawlessly. I wish you could see this spread from a
first timer. It's bad a$$.

"David McRitchie" wrote:

Hi Jeff,

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

Formula1: =$J91 format, patterns, blue

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

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