Previous in Forum: Accountants   Next in Forum: Waste Plastic Recycling and Properties of Cement
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
2 comments
Rate Comments: Nested
PeterR
Active Contributor

Join Date: Oct 2006
Location: Windsor On Canada
Posts: 24

Excel

03/30/2008 6:51 PM

I have a drop down menu in excel, however when one chooses for example "solved" I will like it to be highlited in Green, and when not solved I would like it to be highlited in Red. Any help with this
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Good Answers:

These comments received enough positive votes to make them "good answers".
2
Vulcan
Guru
Philippines - Member - New Member Engineering Fields - Instrumentation Engineering - New Member Engineering Fields - Control Engineering - Who am I?

Join Date: Oct 2006
Location: Northern Mindanao, Philippines
Posts: 2147
Good Answers: 53
#1

Re: Excel

03/31/2008 12:13 AM

I'm not sure what you mean.

  1. You have a drop down menu that has "solved" and "unsolved" as selections.
  2. You want the menu color to change if you select one or the other?
  3. Or do you want the cell color or font color to change if the cell contains "solved" or "unsolved".

I have no answer for #2.

For #3, you can use the Conditional Formating in the Format menu.

You can have up to 3 conditions where you can change the font, border or pattern or a combination of the three.

__________________
 Miscommunication: when what people heard you say differs from what you said. Make yourself understood.
Register to Reply Good Answer (Score 2)
No more Good Answers.
PeterR
Active Contributor

Join Date: Oct 2006
Location: Windsor On Canada
Posts: 24
#2
In reply to #1

Re: Excel

03/31/2008 7:33 PM

Thanks for the reply.

Sorry I was not clear. I was interested in #2, but I will try to work with #3

Thanks,
Register to Reply
Register to Reply
Have a Different Question?
2 comments

Good Answers:

These comments received enough positive votes to make them "good answers".

Previous in Forum: Accountants   Next in Forum: Waste Plastic Recycling and Properties of Cement

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
General Discussion:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (59 right now)
Show Members
Advertisement