| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Highlighting
How can I have a cell automatically hightlight when any data is entered in
that cell. Conditional formatting not working for this. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Highlighting
Select the cell, say A1
FormatCFFormula is: =A1<"" Pick a color and OK. Gord Dibben MS Excel MVP On Thu, 19 Oct 2006 15:18:01 -0700, perezianda wrote: How can I have a cell automatically hightlight when any data is entered in that cell. Conditional formatting not working for this. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Highlighting
perezianda wrote: How can I have a cell automatically hightlight when any data is entered in that cell. Conditional formatting not working for this. This works: Formula Is =CODE(A1)0 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Highlighting
Set the font, colour, etc of the cell when it will have data entered. Then go
to conditional formatting, set 'formula is' =A1="" then set the format to automatic with no fill. where A1 is the cell. "perezianda" wrote: How can I have a cell automatically hightlight when any data is entered in that cell. Conditional formatting not working for this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
