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.