Coloring cells "Red" when certain words are entered
Posted by Noir on November 27, 2001 6:14 AM
I purchase computer products from various vendors around the country. We have determined that 3 or 4 vendors should no longer be used because of bad performance, high prices,etc. (More vendors could be added later) Me and 3 other buyers share a common spreadsheet for tracking purchases. I would like to have the cell color "Red" if one of the 3 or 4 vendor names are enetered (eg:Acme company, TSM company,etc).
Can this be done?