conditional formating a specific amount of cells in a row.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Thank you. That worked flawlessly. I wish you could see this spread from a
first timer. It's bad a$$.
 
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
 
Back
Top