Version: 2004 How do I highlight only the odd numbered cells in an 800+ row document?
T tessp727 Aug 25, 2008 #1 Version: 2004 How do I highlight only the odd numbered cells in an 800+ row document?
C Carl Witthoft Aug 25, 2008 #2 Version: 2004 How do I highlight only the odd numbered cells in an 800+ row document? Click to expand... you mean you want the odd-numbered rows highlighted? Use Conditional Formatting, and select Formula, and type in something like =IF(mod(row,2)=1,TRUE, FALSE)=TRUE and then select the hilight color you want for the 'true' condition.
Version: 2004 How do I highlight only the odd numbered cells in an 800+ row document? Click to expand... you mean you want the odd-numbered rows highlighted? Use Conditional Formatting, and select Formula, and type in something like =IF(mod(row,2)=1,TRUE, FALSE)=TRUE and then select the hilight color you want for the 'true' condition.
