How do I set up a conditional format using the value returned by .
 

The cell reference returns a phone number from a different sheet. If I use
C700 in conditional formatting it formats even those that don't return a
phone number. I think this is because even if there is no phone number
returned, the cell still has a value in it because of the cell reference
formula.

Test for LEN(c70)0 or even for a specific length if all your phone #s are
the same # of characters


"RGDeb" wrote in message
...
The cell reference returns a phone number from a different sheet. If I
use
C700 in conditional formatting it formats even those that don't return a
phone number. I think this is because even if there is no phone number
returned, the cell still has a value in it because of the cell reference
formula.

Hi

what is the formula in the underlying cell?
are you using "cell value is" or "formula is" in Conditional Formatting
what is the range you want to apply the CF to?
what is the exact entry you have in CF?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"RGDeb" wrote in message
...
The cell reference returns a phone number from a different sheet. If I
use
C700 in conditional formatting it formats even those that don't return a
phone number. I think this is because even if there is no phone number
returned, the cell still has a value in it because of the cell reference
formula.