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 / May 2008

Tip: Looking for answers? Try searching our database.

I need help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FrogCWR - 01 May 2008 23:48 GMT
Let me start off by saying that I have been using Excel for several years,
but self taught. I have come across a new challenge that I just can't figure
out. I am attempting to create a formula that will automatically change the
color of a specific cell if another specific cell has ANY TEXT entered into
it.

Here's my example
A1 has a specific goal
B1 has date that the goal is set
C1 will be used to enter date goal is complete

I want to start A1 out as rose colored, but change A1 only to change to
light green if any date is entered into C1, specifying that the goal has been
met.

Is this even possible? Hope someone can help. Thanks.
Dave - 02 May 2008 00:11 GMT
Hi,
Set the default format of A1 to red.
Then try this in the conditional format of A1:
=C1<>""
Set format to light green.
Regards - Dave.

> Let me start off by saying that I have been using Excel for several years,
> but self taught. I have come across a new challenge that I just can't figure
[quoted text clipped - 12 lines]
>
> Is this even possible? Hope someone can help. Thanks.
 
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.