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 |