If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
checking that cells have a value before the workbook will close | kcdonaldson | Worksheet Functions | 8 | December 5th, 2005 04:57 PM |
Conditional formating | Guenzak | General Discussion | 6 | September 27th, 2005 12:20 AM |
how to format only specific characters or numbers within each cellwithin a range of cells | Colleen | General Discussion | 4 | September 12th, 2005 10:04 PM |
Conditional Formating | Danny | Worksheet Functions | 6 | July 5th, 2005 11:01 PM |
Conditional Formating | Mark K | Worksheet Functions | 3 | September 29th, 2004 03:05 AM |