Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Conditional Formatting problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
StompS - 17 Jan 2006 21:17 GMT
I would like a cell to have a background color of yellow if it is empty (ie:
neeeds data input). Once it has data, the background turns off. I used two
conditions in the conditional format command and it doesn't appear to be
working. I used

(cell value) (is equal to) then typed in 2 double quotes with no space in
between for the condition "yellow"

then, condition 2

(cell value) (is not equal to) then typed in the same as above for the
condition "no fill"

I thought it seemd simple enough and it appeared to work at first but then
stopped working.

How do you guys put up with us newbies?   ; )
Signature


StompS
Portland, OR
http://www.geocities.com/pdxinvestr/Stomps.html

Dave Peterson - 17 Jan 2006 21:33 GMT
Format the cell the way you like and you can use just one conditional formatting
rule.

Select the cell
format|Conditional formatting
cell value is  Equal to  =""

and format it nicely.

> I would like a cell to have a background color of yellow if it is empty (ie:
> neeeds data input). Once it has data, the background turns off. I used two
[quoted text clipped - 18 lines]
> Portland, OR
> http://www.geocities.com/pdxinvestr/Stomps.html

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.