auto format cells to highlight only when data is entered

[Mary]

Is there a way to automatically have cells highlight when data is entered. I have a column that only receives occasional data and I would like it to stand out. I'm very new to excel. Thanks

 

[RagDyer]

Try "Conditional Formatting:.
Select the cells in question, then:
<Format> <ConditionalFormat>,
First window - "Cell value is"
second window - "Not equal to"
Third window, two double quotes - ""

Choose your formats, then <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there a way to automatically have cells highlight when data is entered.
I have a column that only receives occasional data and I would like it to
stand out. I'm very new to excel. Thanks

 

[David McRitchie]

Hi Mary,
You are thinking of Conditional Format. See
http://www.mvps.org/dmcritchie/excel/condfmt.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Is there a way to automatically have cells highlight when data is entered. I have a column that only receives occasional data and

I would like it to stand out. I'm very new to excel. Thanks

 

[otium]

Try Conditional Formatting on the cells you want highlighted
Format>Conditional Formatting

You could then specify that Conditional Formattin when Cell Value i
not equal to 0

Then clicl o the format button and define the formatting you want
bold, a specific colour or whatever,

Ala