Cell Highlighting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I have a cell automatically hightlight when any data is entered in
that cell. Conditional formatting not working for this.
 
Select the cell, say A1

Format>CF>Formula is: =A1<>""

Pick a color and OK.


Gord Dibben MS Excel MVP
 
perezianda said:
How can I have a cell automatically hightlight when any data is entered in
that cell. Conditional formatting not working for this.
Click to expand...

This works:

Formula Is =CODE(A1)>0
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
highlighting of cells and columns 1
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
How to Highlight a Row 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Highlight duplicate cells based on a selected cell 5
highlight cells that are included in calculated cell 2
conditional format 1

Back
Top