change color of a row

[Jwalker]

In my worksheet, I have checkbox in column B5:B15. Depending on which row I checked, I want the row color to change to yellow between column C and H. Is it possible to do this? If it is possible, how might I do it?

Thanks for your answer!!

[Bryan Hessey]

In my worksheet, I have checkbox in column B5:B15. Depending on which row I checked, I want the row color to change to yellow between column C and H. Is it possible to do this? If it is possible, how might I do it?

Thanks for your answer!!

It's Conditional Formatting, and the file CF.xls here should help.

http://www.excelforum.com/showthread...=576296&page=2

---