Hi

Have a look he
http://www.cpearson.com/excel/colors.htm
This is one of Chip Pearson's pages - and his site is well worth
bookmarking.

Hope this helps.
Andy.

"Martin Williams" <Martin wrote in
message ...
I want to make the contents of a cell dependant on whether another cell is
highlighted in yellow or not. I can find no way of doing this. I'm using
Excel 2003, but would also like to use on Excel 2000.