Hi Lee,
If by format of another cell you restrict yourself to the font, background
color of cell, or shading pattern then you can use Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Otherwise you would need to use programming, and it would be easier
to answer with a programming question if you stated exactly what you
wanted to do with cell addresses and if it is for an entire column, but
you cannot do that with Excel formulas. A formula cannot change the
value of another cell, and cannot change the formatting of any cell
including itself..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lee" wrote in ...
Does anyone know of a way to check for a value in two different cells, and if
a certain combination of values exists, change the format of another cell?
..