Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions | |||
Conditional Format With SUMIF | Excel Worksheet Functions |