We are trying to print grey scale text. It will only print grey scale when we print in colour and not in black and white?
The images and line fills we are using are printing in grey, just not the text.
We are using excel 2003. Both word and publisher print grey scale?
I have a spreadsheet with rows of cells which are either blank or have text in them.
Is there an easy way to write a formula which will make the cells which have text in them bold and make the cell colour grey. But if the cell is blank keep the cell white.
How can we convert time on a scale of 100 to a scale of 60?
View 3 Replies View RelatedI have a workbook with 3 sheets.
The underlying VBA is password protected and I have the password.
My problem is there is one sheet that I can see in the VBA side of things but cant see on the excel side
Format/sheet/unhide - suggest there is no sheets hidden
If I right click on the sheets (vba side) View object can be seen
except for the one sheet which remains greyed out
Any ideas why this is?
If I try and goto(F5) a range in this sheet nothing happens
If I use a dropdown validation cell, which looks at this sheet it works, except there appears to be a line missing.
I need to find a way to do conditional formatting and disabling of a cell based on a value from another cell. For instance if A1=X,Y, or Z, then B1 will get grayed out and cell entry will be disabled. This is so that when skimming over the sheet, you can tell what cells in row B you need to put info in still, and if it's grayed you'll know you don't have to put anything there (and it won't let you).
View 14 Replies View RelatedFor an excel application I need the disable most of the ribbon content i.e. disable insert, formulas tab etc.
The only thing that should function is a hand build menu add-in, which is created with custum UI editor.
I searched via google, this forum and many other places, but i didnt find a clear answer yet.
Is there a macro that will format unused rows or with no value in a given range. I have a sheet that I am using that some of the date is either added or deleted and would like to have a macro to do grey out unused rows. I am using this with a form control.
View 3 Replies View RelatedEssentially, I'm creating a spreadsheet which contains a list of staff in rows, and the months of the year as columns. It is to record certain company checks which must be done (e.g. driving licence check). When a check is complete, the date it was done is entered under the corresponding month. Certain checks (e.g. driving license) only need to be done every 6 months. What I'm trying to do is find a formula/vba to look at each row, determine where (which month) the date was entered in, and grey out the 5 months in front, meaning the next check is required in 6 months time.
Ideally, the frequency of this check is dynamic, and can reference a cell (e.g. might change to every 3 months etc).
VBA code to disable(grey out) condition formatting command in ribbon. Because I generated a template and do not want user to change the condition formatting.
I have tried below, but it did not work...
Application.CommandBars(1).Controls("Format").Controls("Conditional Formatting...").Enabled = False
I am running into a seemingly random event upon executing a rather long program in Excel VBA: a square area turns gray in the left of the screen in Excel, making invisible everything under it, and affecting every sheet and workbook open. The only way to get rid of it, so far, has been to restart Excel. I thought it pertained to a faulty Office installation (XP/2002), but then it also happened on another machine (with Excel 2003) where I installed the application.
View 4 Replies View RelatedI have information in A1. I want A1 to look at B2:B5 and D2:D5 (Under conditional formatting) and if there is one or more "X" in those cells to color A1 Grey (Fill). I keep trying to put a formula under conditional formatting, but it is only working for the first cell (B2) and not the rest.
View 2 Replies View RelatedI am looking for a way to highlight groups of identical number cells in alternating grey and white. My goal is to make it clear when there is a repeating set of numbers. Below is an example of what a completed state of this would look like that I created manually. The real form I will be using this code on will have long number which is why I am looking for this added clarification. I am using excel 2010.
1
1
2
3
4
[code].....
I am using Excel 2002 and have had a couple of files that seem to have become corrupted recently. When I try to open the files there is nothing there, no cells just a grey space where the cells should be. When I try to close Excel it asks me if I want to save changes when no changes have been made.
I had not made any changes to the sheets prior to this happening so am struggling to work out what is going on.
The scale on our chart in the X axis is mandating a numeric number. It is showing "39200" instead of 4/28/07. In any event, we would like to have 4/9/07 -- the last date we have data for and the last date that we have referenced on the X axis.
The chart is in the attached chart.xls and the data is in the attached chart.xls
A set low number of 100 is in cell B4, and a related set high percent of 18% is in cell B6.
A set high number of 1,000 is in cell D4, and a related set low percent of 14% is in cell D6.
In cell B8 a manual number will be typed between 100 and 1,000.
In cell B10 we want a formula that will roundup a percentage number between 14% and 18% depending on the number inserted in B8.
I am trying to create a scale using IF functions in Excel.
I have a row of numbers that I want to convert to my scale. My scale is fairly simple, less than 1 =1 and more than 10 = 1
After that, any number between 1-2 gets a 10, any number between 2-3 gets a 9, any number between 3-4 gets a 8, etc.
So, what I have done is take a logic if-then function and applied it to my row of numbers. It looks something like this:
=IF(2<D2<3,9)
However, this doesn't work. I have a number (2.55), and instead of showing a 9, it says FALSE. I am pretty sure 2.55 falls between 2 and 3 on the scale. Why won't it work?
Also, is there any way to create a function where I could put each of my if/then functions to create my whole scale? Right now I just have 10 separate columns for each number on my scale.
Here's the scenario. A co-worker and I access the same file from the same online database and download it in the same manner. We have the same version of excel. We then open these identical files, we run a formatting macro (identical), but when it comes time to set the page breaks in order to get the items to print on the same page I have to increase a columns width to make it fit on one page and yet it still doesn't match theirs. It appears to have a different scale but I'm not sure of the option difference between our machines. I don't know how it could be the printer since it physically gives her different page break option than what mine does.
View 1 Replies View RelatedI would like to scale an image to 124% how do I do that
View 1 Replies View RelatedMy display scale is 125%. A college's is set to %100. This causes errors when I place Shapes to saved locations, .Top & .Left programmatically. Based on Google searches, it appears that setting the auto scale mode to DPI may solve this problem. How do I set it?
View 5 Replies View RelatedI have a list of items that each one has starting price, demands and current price. Current price changes by demands according to pre determined scale. Demands values are entered manually by user. I’m looking for a formula that will calculate current price automatically according to the scale & demands. I cannot know what will be the amount of demands (it could be 0 or 5000...) but I do know that demands are sequential integer numbers, positive or negative. I also don’t want it to exceed the minimum and maximum value that determine by user. I think the attached file will explain well than what I’m writing.
View 5 Replies View RelatedI am using a VBA macro which performs a Yahoo webquery to obtain stock data. After the data are downloaded, a chart is updated with the new data.
The current macro updates the scaling on the price axis just fine, however, if I change the time frame the x axis, i.e, time/date axis is either spread out to far or jammed up.
The code for re-scaling the the y axis is shown below:
Code:
Sub UpdateScale()
Dim ChartVar As Chart
Dim lMax As Long, lMin As Long
On Error GoTo ScalingProblem
'Assigns the values in the Min and Max ranges to variables.
[Code]....
Any similar sub that would also rescale the x axis as needed when the data intervals are changed?
I AM TRYING TO WRITE A FORMULAE BASED ON THE FOLLOWING SLIDING SCALE.
0 - 49.99 = 9.9%
50 - 599.99 = FIRST 50 @ 9.9% (4.95) THEN AT 5.8%
600 ABOVE = FIRST 50 @ 9.9% (4.95) + 50 - 599.99@5.8 (32.45) AND THEN 600 ABOVE AT 1.9%
this is what i came up with, but it is not excepting the formulae.
=IF((C4
My question is that i have to scale my data.. Can i do Z-transformation..
Is there any inbuilt function or shall i have to write Code,
Calculate the intensives to be paid to a loan officer based on the number of cases he brings , according to the following :
the first 10 cases 0
from 11 to 15 cases 6 pounds
from 16 to 20 cases 8 pounds
from 21 cases to more 10 pounds
so I need to put the total number of the cases , the loan officer brought in one cell, and this value to be processed and splitted to the segments above , and multiplied with adjacent pounds sums , and finally calculate the total of theintensive to be paid.
I have a big set of data, where I requires to zoom in to view the details of the graph (by scaling the X and Y axis). I am thinking of a graph that can use 4 scroll bar to control the zooming. 2 for each axis, where one control the difference between the maximum and minmum value (Zooming effect, minimum value always the same), and one to scroll the range of the data without zooming, (maximum - minimum) always the same.
View 5 Replies View RelatedI have a Scatter chart that plots a simple XYScatter plot. The data for this plot can be very wide ranging, and for that reason, I use AutoScaling to scale the axes. Nine times out of ten, it works just fine, but it seems that when the X data ranges from about 5200 to 7200 +/-, the autoscaling does not calculate well (example attached).
Autoscale range will go from 0 to 8000, leaving a large area of unplotted graph space.
I thought the original issue was that I may be plotting zeros or blanks, but I've eliminated that problem. I have yet to find another range of values that causes it, but I'm sure there's some. What is it about the way that Excel calculates its AutoScaling that I'm missing?
What do you all recommend to eliminate this problem? Manually scaling it is not really an option in this case, as I want this to be completely transparent to the user for ANY range of data.
I was wondering if there is any way to "grey-out" a commandbutton? I made it using the forms toolbar.
View 3 Replies View RelatedColor Scale Conditional Formatting
I want to use formula to define Minimum, Midpoint and Maximum in the color scale, but am not able to achieve it.
My Criteria are as follows;
Minimum: Less than equals to 50%
Midpoint: More than 50% less than 70%
Maximum: More than 70%
I need this formula for Accuracy column only.
I need a formula to calculate a linear sliding scale from 10%-30% (no higher, no lower). Based on the data in the below chart, if the GROR (let's say this is known and the result resides in cell A1) is less than or equal to 0.0% the payout % is 10.0% and gradually increases as the GROR increases.
The payout % is capped at 30% which is if GROR is 18% or greater. Below are just some examples of how certain thresholds should calculate.
GROR 0.0%5.0% 8.0% 11.0% 14.0% 18.0%+
payout %10.0%10.0%14.6%19.2%23.8%30.0%
I have a row containing numbers from 1 to 4 and I want to use a color scale to differentiate between the cells easier. The problem is, that I have multiple sheets and in some sheets, I get a different color scale, even though I use the same command and color scale.
I've already removed the "conditional formatting" on all worksheets, but the problem isn't resolved. Is there another way to clear the formatting of a cell, besides going to the "Conditional Formatting" tab and clicking "delete rule for entire sheet"?