Hi,

Create a name such as isFormula:
1. Choose Insert, Name, Define and enter isFormula in the Names in Workbook
box
2. Enter the following formula in the Refers to box
=GET.CELL(48,INDIRECT("rc",))
3. Highlight the range you want conditionally formatted and choose Format,
Conditional Formatting
4. Pick Formula is from the first drop down
5. Enter =isFormula in the second box
6. Click Format...

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"JBeaucaire" wrote:


CONDITIONAL FORMATS usually test formula results or do a comparison of
two or more values. Just looking to see if a cell HAS a formula or not,
I'm not sure that's possible as a conditional format.

Are you sure you aren't wanting to format based on the formula results
in some way?


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46839