Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Sum cells that the fonts have diffrent colors

I have a spreadsheet that has cells wich have diffrent font colors. I want to add only the cells that have a blue font and not black or red fonts.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 66 Answers

I think you can do that in the conditional formatting.

Posted on Feb 14, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I purchased a book on January 27, and I inadvertently deleted before I read it. how can I get it back


Accidentally Deleted a Book .cdPopoverMessage { overflow: auto; max-height: 200px; _height: expression(this.scrollHeight > 200 ? "200px" : "auto"); /* IE */; } .cdPopoverMessageHeader { font-family: verdana,arial,helvetica,sans-serif; font-weight: normal; line-height: normal; } .cdPopoverMessageSignpost { color: rgb(153,153,153); } .cdPopoverMessageAttributes { color: rgb(95,95,95); } .cdPopoverMessageBody { font-family: verdana,arial,helvetica,sans-serif; font-weight: normal; padding-left: 2em; padding-right: 2em; } .newSinceLastContent { color:#009900; font-size: 9px; margin-bottom:10px; padding-left:2px; } .newSinceLastImage { float:left; } .fontGrey { color: #797979; } .cmPage em { font-weight: bold; font-style: normal; } .postOfficialSignpost { padding: 6px 15% 0px 17px; } .postBody { padding: 3px 5px 5px 5px; margin-left: 8px; } .postHeader { font-size: 9px; padding: 10px 10px 0 0; text-align:right; } .postFrom { padding: 0 0 7px 0; } .postFromBadges { padding: 1px 0 0 19px; } .postEditNameLink { font-size: 9px; } .postContent { line-height:140%; padding-top: 2px; padding-right: 15%; padding-bottom: 8px; padding-left: 17px; font-family: verdana, arial, helvetica, sans-serif; font-size: small; } .postFooter { padding: 0px 10px 0 17px; } .postFooterRight { font-size: 9px; text-align:right; } .postFooterLeft { float: left; } .postRating { margin:3px 10px 0 0; font-size: 9px; text-align:right; } .postFooter, .postRating, .postHeader { /* color: #666; */ } .postBody em { color: #c60; } .cdReplyLink { padding-top: 0.5em; border-bottom: 1px dashed; display: block; } .cmPage .cdReplyLink a:hover { text-decoration: none; border-bottom: 1px dashed #c60; } .cdReplyBox { clear: both; display: none; margin-top: 0.5em; } .cdEditBox { clear: both; display: none; margin-top: 0.5em; } .cdPostBoxHeader { font-weight: bold; background-color: #dbedf9; padding-left: 12px; padding-top: 5px; line-height: 1.6em; font-size: 10px; } .cdPostBoxOuter { background-color: #dbedf9; padding: 0em 2em 0.2em 6em; border-bottom: 1px solid #b4c9e8; } .cdBoardViewerBevel { clear: both; margin-bottom: 1px; border-bottom: 1px solid #a1bed3; } .cdPostBoxBucket { background-color: #dbedf9; border-bottom: 1px solid #a1bed3; padding: 0.5em 0; } .cdPostBox { /* width: 90%; margin: 0 auto;*/ padding: 0 12px 0 12px; } .cdPostBox form { margin: 0; padding: 0; } .cdPostBox textarea { width: 100%; -moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box; height: 8em; font-family: verdana,arial,helvetica,sans-serif; font-size: small; _font-size: x-small; line-height: 140%; } .cdPostBoxInputs { float: left; _height: 30px; } .cdPostBoxInputs input { margin: 6px 0; } .cdGuidelinesLink { margin: 0.5em 0 0 0.5em; font-size: 0.9em; float: right; } .cdEditBoxAttribution { padding: 0em 1em 1.25em 1em; } .cdClear { clear: both; height: 0; line-height: 0; font-size: 0; width: 100%; } .cdIgnoreStatus { display: none; color: #c60; font-weight: bold; padding: 0; margin: 4px 0 4px 0; } .jsDisplayTog { display: inline; } .cdPostError { color: red; } <style> .jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }< /style> <style> .jsDisplayTog { display: none; } .cmPage .postBody .postFrom .iconImg { visibility: hidden; }< /style> .cdPostError { color: red; } .cdCommentPostBox .fontGrey { color: #AAAAAA; } .cdCommentPostBox .fontRed { color: #FF0000; } .cdNonReplyPostBoxBevel { clear: both; height: 0; font-size: 0; width: 100%; border-bottom: 1px solid #a1bed3; margin-bottom: 1px; } .cdNonReplyPostBoxHeader { font-weight: bold; background-color: #dbedf9; padding: 5px 12px 0 12px; font-size: 13px; } .cdNonReplyPostBox { padding: 0.5em 12px; background-color: #dbedf9; border-bottom: 1px solid #a1bed3; } .cdNonReplyPostBox .tiny { font-size: x-small; } .cdNonReplyPostBox a { text-decoration:none; } .cdNonReplyPostBox a:hover { text-decoration:underline; color: #c60; } .cdNonReplyPostBox em { font-weight: bold; font-style: normal; } .cdNonReplyPostBox div.cdFormRow { width: 100%; clear: both; margin: 0; } #cdNonReplyPostBoxForm { margin: 0; } .cdNonReplyPostBoxInputs { margin: 6px 0; } .cdNonReplyPostBoxInputs input { margin: 0 6px 0 0; } .cdNonReplyPostBox .cdPromptWrapper { text-align: center; float: left; } .cdNonReplyPostBox .cdGuidelinesLink { margin: 0.5em 0 0 0.5em; font-size: 0.9em; float: right; } .cdNonReplyPostBox textarea { width: 100%; -moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box; height: 8em; font-family: verdana,arial,helvetica,sans-serif; font-size: small; _font-size: x-small; line-height: 140%; } .cdNonReplyPostBox text { font-family: verdana,arial,helvetica,sans-serif; font-size: small; } .cdNonReplyPostBox .cdPromptFor { font-size: 9px; } .cdNonReplyPostBoxMsg { padding: 0.5em 12px; background-color: #dbedf9; border-bottom: 1px solid #a1bed3; font-size: x-small; } .cdNonReplyPostBoxAddedToThreadMsg { font-weight: bold; color: #cc6600; } .cdNonReplyPostBoxOtherMsg { color: red; padding-top: 0.5em; } .cdPageSelectorHeader .tiny { font-family: verdana,arial,helvetica,sans-serif; font-size: x-small; } .cdPageSelectorHeader a, .cdPageSelectorPagination a { text-decoration:none; } .cdPageSelectorHeader a:hover, .cdPageSelectorPagination a:hover { text-decoration:underline; color: #c60; } .cdPageSelectorHeader, .cdPageSelectorPagination { border: 1px solid #5c9ebf; padding:6px; height:21px; box-sizing: content-box; background: url(http://g-ecx.images-amazon.com/images/G/01/nav2/images/gui/tile-blue-bg._CB46870869_.gif) repeat-x; background-color: #b7d7e6; margin-top:8px; margin-left: 8px; } .cdPageSelectorHeader .cdPageInfo { margin-top:2px; } .cdPageSelectorHeader .cdPageSort { float:right; margin:4px 2px 2px 2px; } .cdPageSelectorPagination { padding: 4px 0 4px 0; color: #666; text-align: center; } .cdPageSelectorPagination a { padding: 3px; } .cdPageSelectorPagination a:hover { background-color:transparent; } .cdPageSelectorPagination a:hover { border: 1px solid #c60; color: #c60; text-decoration:none; padding: 2px; } .cdPageSelectorCurrentPage { border: 1px solid #c60; color: #c60; text-decoration:none; padding: 2px; background-color:white; } #cdNonReplyPost { margin-top: 8px; margin-bottom: 12px; } .cdMovedMessage, .cdLockedMessage { margin-top: 8px; margin-bottom: 12px; color: #666; } See latest post
Sort: Oldest first ' Newest first Showing 1-25 of 29 posts in this discussion Initial post: Mar 2, 2011 8:35:31 AM PST Andrea Solek says: I was in the midst of organizing my newly purchased books on my kindle yesterday when I accidentally removed one. It was a freebie, thank God. But when I went to re-"purchase" it, Amazon tells me I already own it.

Is there a way to recapture the lost book back on to my kindle? Reply to this post Permalink ' Report abuse
1 of 1 people think this post adds to the discussion. Do you? Yes No In reply to an earlier post on Mar 2, 2011 8:36:22 AM PST ShirleyKat says: Look in your archived items (Home, Menu, View archived items). Just click and it will be back soon. Reply to this post Permalink ' Report abuse
6 of 7 people think this post adds to the discussion. Do you? Yes No Posted on Mar 2, 2011 8:37:02 AM PST J. Harnden says: Sure, go to your archive folder on your Kindle and click on the book you deleted and it will re download it back to your kindle :) Reply to this post Permalink ' Report abuse
3 of 4 people think this post adds to the discussion. Do you? Yes No In reply to an earlier post on Mar 2, 2011 8:37:29 AM PST M. Francis Professor of Kindology says: It should show up under archived items on your home page. Be sure your wireless connection is on, then just click the title under archives.

Or, you can go to Manage Your Kindle right here. Scroll down to the list of books you've bought. When you get to the title, you'll see where you can re-send the book to your Kindle. Reply to this post

Jan 29, 2016 | Tablets & eReaders

Tip

How to Unlock an Ipod using Windows


If you ever accidently locked yourself out of your iPod this is the easiest way to UNLOCK an iPod

FIRST CONNECT iPod TO COMPUTER/LAPTOP (using a USB cable)

On your desktop click on Microsoft

start button, then choose Run..

type this exactly

J:\ipod_Control\Device

then click

OK

tip: use the letter representing your ipod driver, for example

J...(you can find your letter by clicking
My computer then see your ipod name under that letter)

there will be a file named

_locked

you then right click on it and choose

Rename, you then type

unlocked

then press Enter

OR

you can just

delete the file named _locked

now close window

and

safely disconnect usb driver (this would be either on your icon tray or you could use itunes or any other media player that has an eject button)

CONGRATZ YOUR iPod IS NOW UNLOCKED AND READY TO BE ENJOYED AGAIN

ps...have not tried it, but....

if you have a locked iphone or itouch, this just might work for it too.....

instead of

J:\ipod_Control\Device

replace

ipod to iphone or itouch, get it?...

Good!...

Now have FUN!!!

 

 

on Jan 15, 2012 | Microsoft Computers & Internet

Tip

How To Properly Store Vegetables and Food


The first step in proper storage is making sure your refrigerator is at the proper temperature. You will want to make sure your fridge is somewhere between 34 degrees and 40 degrees Fahrenheit. If your fridge goes above 40 degrees, your food will spoil more quickly, but if the temperature is too low, the vegetables in your drawer will freeze.



Often, crisper drawers will have a mechanism to regulate how much moisture flows into and out of the drawer. Depending upon which vegetables you are storing, set the drawer to either let moisture out for drier veggies or keep moisture in for vegetables that need the humidity. Having a fridge with multiple crisper drawers is helpful in storing vegetables based upon their humidity needs.



Vegetables tend to be very sensitive to ethylene, a substance that comes from most fruits and a select number of vegetables. Because of this, storing fruits and vegetables separately is advised. Ethylene exposure is responsible for carrots turning bitter, the yellowing of certain green vegetables and lettuce turning brown. In addition to absorbing ethylene, some vegetables also absorb odors from other veggies. For example, the odor of apples is absorbed by carrots, cabbages and onions. If odor absorption occurs, it can affect the taste of the vegetable. Add a box of baking soda to the crisper drawer to help with odor absorption. After about two weeks, you'll want to shake out the top layer of the baking soda to maximize freshness.



Some vegetables benefit from being stored in a bag in the refrigerator rather than being out of a bag. These vegetables, such as artichokes, broccoli, cauliflower, cabbage and eggplant, should be placed in the crisper bin in perforated plastic or paper bags so that they can maintain moisture. However, some vegetables like lettuce don't do well with lots of moisture; for this reason, you should not wash your vegetables before storing, but before eating instead. With carrots, beets, radishes and parsnips, removing their tops prior to storage will help them keep longer. Similarly, the head of celery stalks should be covered before storing.

on Oct 19, 2011 | Frigidaire Refrigerators

1 Answer

Is there a way to change the font color of files and folders names in a flash drive?


I found it, from another web site. SmartUSB.net.


It explains step by step, how to change font color in a flash drive.


Change font color in your flash drive

http://www.smartusb.net/p/change-font-color-of-your-flash-drive.html


Show your colors to your brother.


Change your flash drive icon

http://www.smartusb.net/p/change-flash-drive-icon.html


Insert symbols to your flash drive label

http://www.smartusb.net/p/insert-symbols-to-flash-drive-label.html


Hide a file or folder in your flash drive

http://www.smartusb.net/p/hide-file-or-folder-in-flash-drive.html


Add wallpaper to your flash drive background

http://www.smartusb.net/p/add-wallpaper-to-flash-drive-background.html


.

Jul 25, 2012 | Electronics - Others

1 Answer

CAN I USE HEADPHONES?


Hello. Your tv has one audio output jack on the back. 1 x audio line-out ( RCA phono x 2 ). Go to any Radio Shack, tell them what you have [RCA phono x2] so they sell you the correct headphones.

Regards, joe.

Nov 23, 2009 | Sansui HDLCD-2600 26 in. LCD Television

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

Related Topics:

70 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...