| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Fornmatting Text and numbers
Hello this is my conditional formating = " " and this works fine except
that when there is a number in the cell it does not work. How can I do this without having to convert the numbers to text? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Fornmatting Text and numbers
If you want to highlight fields which are TEXT i.e. are not blank or numeric
, use: =TEXT($A1) for your CF HTH "Wanna Learn" wrote: Hello this is my conditional formating = " " and this works fine except that when there is a number in the cell it does not work. How can I do this without having to convert the numbers to text? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Fornmatting Text and numbers
.... sorry typo ....should have been =ISTEXT($A1)
"Toppers" wrote: If you want to highlight fields which are TEXT i.e. are not blank or numeric , use: =TEXT($A1) for your CF HTH "Wanna Learn" wrote: Hello this is my conditional formating = " " and this works fine except that when there is a number in the cell it does not work. How can I do this without having to convert the numbers to text? thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Fornmatting Text and numbers
Hello
I want to highlight the field whether is text or not. "Toppers" wrote: ... sorry typo ....should have been =ISTEXT($A1) "Toppers" wrote: If you want to highlight fields which are TEXT i.e. are not blank or numeric , use: =TEXT($A1) for your CF HTH "Wanna Learn" wrote: Hello this is my conditional formating = " " and this works fine except that when there is a number in the cell it does not work. How can I do this without having to convert the numbers to text? thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Fornmatting Text and numbers
Try:
=NOT(ISBLANK($A1)) "Wanna Learn" wrote: Hello I want to highlight the field whether is text or not. "Toppers" wrote: ... sorry typo ....should have been =ISTEXT($A1) "Toppers" wrote: If you want to highlight fields which are TEXT i.e. are not blank or numeric , use: =TEXT($A1) for your CF HTH "Wanna Learn" wrote: Hello this is my conditional formating = " " and this works fine except that when there is a number in the cell it does not work. How can I do this without having to convert the numbers to text? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS | Excel Worksheet Functions | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| conditional formatting with numbers and text | Excel Worksheet Functions | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
Linear Mode
