I want to place conditional formatting on about 120 rows, over columns A-G. The condition is that if the value of Cell Gn = "This", then columns A-G of Row n should be bold and italicized. I can get it to work for one row at a time, but not for the entire 120 rows. Setting the condition 120 times is not productive. Is there a way to do what I want to do? I am using Excel 2007. Thank you.
Bookmarks