| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlighting text
I'm attempting to do some conditional formatting on text. I need to
highlight cells by itself that contain any text in the cell . is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highlighting text
Possible. REfer the below link for help
Cell value is "text" (within quotes). http://www.contextures.com/xlCondFormat01.html -- If this post helps click Yes --------------- Jacob Skaria "ganga" wrote: I'm attempting to do some conditional formatting on text. I need to highlight cells by itself that contain any text in the cell . is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highlighting text
Any text?
CFFormula is: =ISTEXT(A1) Anything? CFFormula is: =A1<"" Gord Dibben MS Excel MVP On Wed, 24 Jun 2009 06:13:01 -0700, ganga wrote: I'm attempting to do some conditional formatting on text. I need to highlight cells by itself that contain any text in the cell . is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highlighting text
Thank you..it really helps
"Gord Dibben" wrote: Any text? CFFormula is: =ISTEXT(A1) Anything? CFFormula is: =A1<"" Gord Dibben MS Excel MVP On Wed, 24 Jun 2009 06:13:01 -0700, ganga wrote: I'm attempting to do some conditional formatting on text. I need to highlight cells by itself that contain any text in the cell . is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlighting text | Excel Discussion (Misc queries) | |||
| Highlighting Text within Cell | Excel Discussion (Misc queries) | |||
| Highlighting cells with a certain text | Excel Discussion (Misc queries) | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
| Highlighting text using conditional formatting | Excel Discussion (Misc queries) | |||
Linear Mode
