Thank You! Elegant solution!


On Thursday, April 23, 2009 11:26:17 AM UTC-5, T. Valko wrote:
One way...

**Select cell A1** (this is important!!!)

Create this named formula
Goto the menu InsertNameDefine
Name: IsFormula
Refers to: =GET.CELL(48,A1)
OK

Now, apply the formatting

Select the cell(s) you want to format.
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=IsFormula
Click the Format button
Select the desired style(s)
OK out

Cells that contain formulas will have the format applied


--
Biff
Microsoft Excel MVP


"Riaan" wrote in message
...
I wish to use conditional format type functionality to distinguish between
cells that have values only in versus cells with formulas in.