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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Test for LEN(c70)>0 or even for a specific length if all your phone #s are
the same # of characters
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
Excel Conditional Formatting 1
Conditional Format Excel 2007 6
Conditional Format 9
Excel Macro to automatically go to the right of the last colored cell 0
Excel formula, sum the value cell and if empty cell left blank 0
Vlookups and formats 3
identical formula returns #VALUE! error 3

Back
Top