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

Unable to type in microsoft excel spreadsheet


Couple of possibilities:

The active window is selected.

Some cells might be formatted for numbers only. Check cell format.

Your font is white and you can't see your typing.

Oct 03, 2010 | Microsoft Office Excel 2007 Full Version...

1 Answer

Excel 2003 cell is highlighted, font color is selected, but the color on the screen remains black. When printing the color prints out correctly while showing black on the screen


to remove all formats....
i.e.
open another workbook....
copy all data from the present sheet to the new work book....
present workbook
select data/edit/copy

new work book
select cell edit/paste special/values

now do the formating/color/font/size etc in the new workbook and check if they work here

Dec 14, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Change Font color in an excel spreadsheet and it prints correct color but will only show as black on screen.


Make sure you have highlighted yhe area you want to change the color on then click on the color you want and it should change for the screen as well as the printing phase of the program.

Dec 14, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

How to recognize hyperlink cells


try to close your workbook. After a while you try to open it so that the dimmed color for "visited links" disappears.

Regards!

Jul 10, 2009 | Microsoft Office Excel 2007

1 Answer

Outlook 2003 font format removed after sending


It depends on the settings of the receiver's email program.

Mar 18, 2009 | Microsoft Computers & Internet

1 Answer

Unable to load post script fonts in windows-xp


Well postscript fonts are vector outline fonts, so they contain instructions about the building of their outlines and curves and such. Hence two files are required to use a postscript font under Windows.

As to how to install these fonts, well
  1. Click Start | Settings | Control Panel.
  2. Double-click on the Fonts folder.
  3. Choose File | Install New Font.
  4. In the Folders menu, navigate to the folder containing the fonts that you wish to install. A list of available fonts will appear in the List of Fonts window.
  5. Click on the font you wish to install or use the "Select All" button to install all fonts in the List of Fonts.
  6. Click on OK.
Please keep in mind:
  1. If you are installing fonts from a CD be sure the 'Add without copying files' box is NOT checked; unless the fonts are on a located somewhere (such as a network) which you will have access to at all times.
  2. Postscript fonts have two files: PFB (printer font binary has outlines that control how the font looks) and PFM (printer font metrics has information about font spacing). Be sure you have both font files.
  3. If you currently have or previously had Adobe Type Manager Deluxe 4.0, 4.1, or 4.1.1 installed you may need the Adobe Deluxe Updater in order to properly use your Postscript fonts under Windows XP. Get it from Adobe.
Hope this helped. Let me know and if yes please rate me:)

Feb 15, 2009 | Adobe Computers & Internet

2 Answers

How to do profit and loss a/c in ms excel


Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)



Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)


I hope this helps

Mark

Jan 05, 2009 | Microsoft Computers & Internet

1 Answer

Microsoft works


First check the formatting of the cells, then check under file-preferences to see what works is programmed to do, if this gives no clue, you could easily create a copy to experiment on and on the copy, highlight the entire sheet, and clear all functions and formats, then experiment with your calculation, if it performs ok, you will know that there was something else going on in the original cells. Finally, instead of the auto-sum function you could manually put in the sum formula eg D2=sum ( A34:A57)
If all this fails, post back and we'll dig further......good luck

Jan 03, 2008 | Microsoft Works 8.0 for PC

1 Answer

How to formatting by format field property.


Right-click the field in the form, and select Properties. Under the ALL tab, look for the Font colour, font style, etc). For queries, select the blank area in design view, and click the "Build" icon on the Query Design toolbar. Use the expressions as you would in Excel.

Sep 13, 2007 | Microsoft Office Standard for PC

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

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18331 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...