A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Conditional Formatting - Code to colour 3+ text values differently by AK9955
Hi, In my spreadsheet I would like to highlight 3+ text values in bold and different colours. E.g. New = green/bold, Modify =blue/bold, Delete = red/bold,...
November 9th, 2009 07:11 PM
by Gord Dibben Go to last post
3 243
x if six cells are blank by Jim
Hello, I have about 5k lines of data. Columns A, B and C all have data. D, E, F, G, H and I may or may not have data. In K I would like to have a formula...
November 9th, 2009 07:00 PM
by Rick Rothstein[_2_] Go to last post
4 209
How can I show and print text with line breaks within cells? by Julie
I have many cells containing several lines of text using line breaks. I cannot see the text or print it. I can only see it if I select a cell. How can I...
November 9th, 2009 06:49 PM
by Jacob Skaria Go to last post
1 184
How to get the full list of drop down menu by Carol @ Prison[_2_]
Hi guys, We have recently been changed to Vista from XP, we created a spreadsheet in Excel whilst still using XP (and have not converted it to Vista, but...
November 9th, 2009 06:41 PM
by Bob I Go to last post
1 181
2003 spreadsheet - gridlines won't print when opened in 2007 by gayle
Help! When I open a spreadsheet in 2007 that was created in an earlier version, I go to Pagelayout and I check off that I want to view and to print the...
November 9th, 2009 06:37 PM
by Bob I Go to last post
1 189
Variable substitution by doobie
I need a fn to substitute for a variable value in a SUM fn., in other words my problem as indicated in below table (Hrs) 2 2 3 1 Student ...
November 9th, 2009 06:36 PM
by Dave Peterson Go to last post
1 143
excel by pathenno
how do i enter weekly dates in cells eg 8/11/09....15/11/09...22/11/09....etc..etc
November 9th, 2009 06:30 PM
by Bob I Go to last post
3 160
function query - not sure which one possibly vlookup by Lainyb
I am trying to pick information on salary spinal column points within certain grades. I want to look at the current scp in cell J2 and then get the next scp...
November 9th, 2009 06:27 PM
by T. Valko[_2_] Go to last post
7 193
Excel 2003 Conditional formatting challenge question by John C.
I am familiar with how to find a min and max value in a table and change the color of the cell and even the font to bold. However, I am stumped with this...
(Multi-page thread 1 2)
November 9th, 2009 06:11 PM
by Jacob Skaria Go to last post
11 269
How to open XLSM file in IE9 by Manuelauch
I try to open an XLSM file using IE9, but it this is what happened: The workbook will load and there is indications (I check Windows Explorer) that it is...
November 9th, 2009 05:55 PM
by Manuelauch Go to last post
0 167
Printing multi-pages by yclhk
I print the excel file with two pages in one sheet using the print option selecting in the printer console, however, the some grid lines are found missing in...
November 9th, 2009 05:50 PM
by Bob I Go to last post
1 163
Using percentages by GENO
I am using percentages to calculate a score of 1 - 5 which updates a dashboard. I have an average of multiple scores adding up to 100% or less. I would like...
November 9th, 2009 05:36 PM
by Jacob Skaria Go to last post
4 152
StatPlus by ks
I needs to use the StatPlus function. Does it in the student version?
November 9th, 2009 05:10 PM
by David Biddulph Go to last post
1 128
Completing Formula For Hours Worked by it''''''''sh hardy
Hello! - I have an excel sheet that is totalling for hours worked, but if someone works over 24 hours, the total starts over from 0 hour then again up to...
November 9th, 2009 04:56 PM
by David Biddulph Go to last post
3 135
Simple concatenation including date by mike_vr
Hi there Trying a very simple concatenation =A18 & " " & B18 but the problem is, B18 is a date. So whenever it calculates it comes back as "National...
November 9th, 2009 04:53 PM
by John Go to last post
3 148
Images in embedded worksheet do not print correctly by Glendino
Excel 2007. Having embedded a worksheet into a sheet, the images in this embedded worksheet, though displaying correctly on screen, do not print in the...
November 9th, 2009 04:26 PM
by Glendino Go to last post
0 170
Dates for Hyperlinked Documents by Budman0527
I have a spreadsheet that I am working on that has hyperlink's in it. I would like to put a cell right beside the hyperlink telling the last time that the...
November 9th, 2009 04:17 PM
by Budman0527 Go to last post
0 116
how to add 3/4 as a fraction by Sean
how to add 3/4 as a fraction like (alt 171) ½ (alt 172) ¼
November 9th, 2009 04:05 PM
by Eduardo Go to last post
1 151
Converting hijri date to gregorian date by Ramil Marbella
good evening, How can i make a formula to automatically convert the hijri date to gregorian date: A B 21/11/1430 ...
November 9th, 2009 03:59 PM
by Ramil Marbella Go to last post
0 176
MS Office XP SBE & Windows Vista 64bit by JWhitehead
I have a user who is using MS Windows Vista 64bit and MS Office XP SBE. When the user tries to open any Excel documents from the desktop, by double clicking...
November 9th, 2009 03:57 PM
by JWhitehead Go to last post
0 157
Post New Thread


Display Options
Showing threads 10301 to 10320 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.