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

R

RGDeb

The cell reference returns a phone number from a different sheet. If I use
C70>0 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.
 
D

Duke Carey

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

JulieD

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?
 
Top