View Single Post
 
Old 03-15-2012, 03:19 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

List 100 words on the spreadsheet like I did. The formula goes in the conditional formatting section, just the same as my example except you need to change the ranges it uses. Conditional formatting tutorial is here:
http://www.contextures.com/xlcondformat03.html
__________________
Colin

RAD Excel Blog
Reply With Quote