Use of Conditional Formatting:
http://www.mvps.org/dmcritchie/excel/condfmt.htm
http://www.mcgimpsey.com/excel/conditional6.html
http://www.datapigtechnologies.com/ExcelMain.htm (videos, look for word "Conditional")
---
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

"JE McGimpsey" wrote in message ...
I meant to use that formula in your Conditional Format (i.e., "CF").

In article ,
"Gee-off" wrote:

Thanks, but how do I input your "=ABS(C1-A1)<0.0000001" over a formual that
already exists in that cell?