I found this in this link:
http://www.j-walk.com/ss/excel/usertips/tip045.htm
1. Select Insert, Name, Define.
2. In the Define Name dialog box, enter the following in the 'Names in
workbook' box: ContainsFormula
3. Then enter the following formula in the "Refers to" box:
=GET.CELL(48,INDIRECT("rc",FALSE))
4. Click Add, and then OK.
5. Select all the cells to which you want to apply the conditional
formatting.
6. Select Format, Conditional Formatting
7. In the Conditional Formatting dialog box, select Formula Is from the
drop-down list, and then enter this formula in the adjacent box:
=ContainsFormula
8. Click the Format button and select the type of formatting you want
for the cells that contain a formula.
9. Click OK.
--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=489076