Hi,

In order to get alternating rows to be highlighted, and the rows to stay that way when I sorted the data, I used the formula =MOD(ROW(),2)=0 to create a rule in conditional formatting. However, now wherever this rule took effect, I can't format further. For example, I want to bold two columns, but only the rows that aren't highlighted because of the rule are bolding. Any suggestions?