I have a spreadsheet where the user wants gray and white lines to occur starting from row 36. Meaning row 36 is grey row 37 white 38 grey etc. to make it look like old accounting paper. The problem is there is a macro that runs to hide the zeros so I cannot preformat the rows because they will change along with the worksheet. Also, the coloring should stop when there is nothing more in the rows, usually around row 100.
View 9 RepliesI have a *.bmp image file. It is gray scale only. It amy be up to 1000 x 1000 pixels.
I want to extract the numerical value of each pixel and deposit the values into an Array for further processing.
if I can gray out the unused columns. I am creating a template that use only column A to J. I don't want user to be able to see or scroll to the unused columns. Is there any command in the setup that can gray out the unused columns? or maybe VBA codes?
View 2 Replies View RelatedHow do I gray out one group of cells or cell if another is occupied?
View 9 Replies View RelatedI'm working on a worksheet that another person started. For some reason there are dotted gray lines around every single cell in the print area in the print preview (no idea what this person did or who this person is, so I can't ask them). Anyhow, I need to get rid of these dotted gray lines. Clicking on no borders does not work.
View 9 Replies View RelatedIF the list value in D2 is = to MT,GP,or H then I need the entire row 2 to turn light gray.
View 6 Replies View RelatedI have a spreadsheet with Ethnicity (White, African American, hispanic,
Asian, other) in column A and Time (hh:mm:ss) in column B.
I trying to determine by how many White, for example, have spent less than 5
hours, >5 hrs but less than 10 hr, etc.
My plan is to make a chart of the data.
I've been looking at sumproduct and COUNTIF but I can't quite figure it out.
i dont know what that 'white' thing called. After i copied the data from other sources, i cant delete the 'white' thing. even i delete the whole sheet, the 'white' thing is still there.
View 2 Replies View RelatedI'm making five charts on one sheet and there's so much white space. I removed the border, got rid of the plot area, and have tried to send the charts back but there's so much white space. QUESTION: Is there a method to elimite white space on a chart/graph?
View 2 Replies View Relatedthis is the code i'm currently using to enter a formula into a cell
View 9 Replies View RelatedHow do I remove the white space in charts?
Whenever I draw a pie chart, I see lot of empty space around the pie. When I try reducing the size of the chart, pie also shrinks. I want to be able to reduce the extra white space 'around' the pie in the chart.
I have a worksheet that contains 3 colors. I sort the worksheet by 2 cell colors, moving them to the top.
I would like code to delete any rows whose cell color in column A is white, leaving only my two other colors.
Can this be done?
I'm working on a project and am particularly new to the whole excel world (especially with macros). Currently, my boss has some data that needs to be refined and organized. Until I get a sense how to have a macro do everything all at once, I plan on have macros do each step more quickly.
Right now, the macros my boss has given me allows the data to be organized into clusters. Each cluster is separated by client IDs in column C. Each cluster is separated by a blank row. We are looking for clients who have not paid their dues and are marking their unpaid dues with colored rows. The dues that are paid are left as white. However, there are clients who do pay their dues, leaving their entire clusters white. I was wondering if there is a macro to remove those fully white clusters.
Using VBA, how can I determine if a cell contains only white spaces and NO valid characters?
View 2 Replies View RelatedHow you can print cells that have a large amount of text continuously on every page (like in an MS Word document)? I have cells that end up with a lot of text, but excel will push the next text heavy cell to the next page leaving you with a few inches of white space on the previous page. Is there a way to just continue the printing of one cell onto the next page to make all the pages even? It takes up extra paper and looks bad when printed...
View 3 Replies View RelatedI generate a somewhat textual report of my calculations. Dependent upon the variables, some lines of my generated text end up blank. I need a way to automatically condense the report, eliminating all unnecessary blank lines.
For example:
Line1 Line1
Line2 Line2
blank Line4
Line4 Line7
blank intentional blank
blank Line9
Line7
intentional blank
Line9
Example file attached... actual data, but static. In real file, the data is dynamic, so I included two examples.
Formatting charts is difficult so I'm trying to find a macro that adds me data labels (in the middle) and color these in white in my active spread sheet as shown in the image.
View image: Example
I was trying recording the macro but it was too many commands, is there a simple way to achieve this?
I have a a worksheet with a drop down menu in one column to show various completion status options (Not started, In progress and Completed). I was able to use conditional formatting to change the color of the cell to gray when I choose "completed" from the drop down menu, but I would like the whole row in view (about 8 cells across) to shade to gray when I choose "completed" from the drop down - not just the completed cell. I'm thinking an IF statement would work, but I don't know how to use an IF statement to shade a range of cells a color.
View 3 Replies View RelatedThis is a delima I cannot figure out. I had to create passwords for a website we are building. I have 3000 employee numbers has to be used. So what i did was took the first initial and middle initial and last initial and first 5 of the ID number. I did a comma delimiter to obtain all of the letters and numbers. example: ABC12345
My problem is none of the passwords work because when I imported the letters and numbers into the sheet it looks just like the above. However on review I cut and pasted back to notepad and the data looks like this:
"A B C 12345"
So its adding a tab in the password thats thats a problem, How do I remove this extra white space between each comma delimited digit? without having to manually delete it ?
I was wondering it were possible to reference an error. I'd like a cell to have white text if $O19 produces a #N/A error. I tried formula
=($O19=#N/A)
and the formula
=($O19="#N/A")
The entries are made in Columns A thru C. In Columns F and G I want any value over 100% to have a red background, any value less than 100% to have regular formatting, and I'd want percentages to have white font if an employee is deleted from Column A.
Here's an example of how I have the formatting set up:
Condition 1: Formula is =$E$2="" --->white font
Condition 2: Cell value is >1 ---->red background
Condition 3 Cell value is </= 1 ---->normal format
I'm trying to write a VBA script which will delete all rows in my Excel spreadsheet where Column I (which contains a status code) does not contain the word "Completed".
At the moment, I'm doing this the other way round: my script is able to search for entries in Column I which contain the status codes "Pending", "Awaiting Authorisation", "In Progress" etc and delete them. The idea is that when all those rows are deleted, I'll only be left with rows which have a status of "Completed". This works fine at the moment. However, the concern is that if a brand new status code is added to the data file, my script would be unable to pick it up and delete it. This is a small sample of the code I'm currently using (which deletes all the rows with statuses other than Completed):
I 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].....
The first code hides everything just fine based on the date in A1. When I change it to the second code to delete instead of hide it is leaving a bunch of rows that the 1st code hides. Both codes have the same search criteria.
Code:
For Each cell In Range("B8:B5000") If cell.Value Range("A1").Value Then cell.EntireRow.Hidden = True
Next cell
Code:
For Each cell In Range("B8:B5000") If cell.Value Range("A1").Value Then cell.EntireRow.Delete
Next cell
So I have been playing around with the tab colors on my workbook and am trying to figure out the correlation between color brightness and the auto change from black text to white text. I've noticed that if the Green color value is higher, excel is more likely to use the black text. If Blue is high, white. Green takes precedence over Blue and Red is just kind of in its own world.how excel calculates this?
View 2 Replies View RelatedI have attached the spreadsheet for reference. All other sheets pull information from the WHITE sheet.
I want the columns for unit price, discount and total to be set to two decimal places but I also don't want it to show anything if the field has a 0 value (so if i only have a few items I don't get lots of o's).
To get the field to not display a 0 if it is empty on the WHITE sheet I have been using "0;-0;;@" which I found on the net. If I use this then it negates the two decimal places.
This also includes the WHITE sheet.
I need to write a macro where i need to copy set of rows from few columns of an excel sheet to another set of columns in same sheet . My excel looks something like this...
Product
F1020
F1023
F1025
F1120
F1123
F1125
[code].....
Now when i filter this table for Product PR01 only rows 1,3,4 will be visible while the other rows remains hidden
I WANT TO COPY ROWS COMING UNDER COLUMNS
F1120
F1123
F1125
TO
F1020
F1023
F1025
when i use the code
Selection.SpecialCells(xlCellTypeVisible).Copy
i get to select ones those are visible but i am not sure how i can PASTE them to rows visible under column f1020 to f1025
Tried this in a frantic effort
Selection.SpecialCells(xlCellTypeVisible).PasteSpecial xlValues
But got an error for " multiple selection"
I have an excel file that i need to delete some empty rows in the file. it looks like this: I have to delete THE EMPTY ROW above each custom table, and leave everything else as it is.
empty row
custom table
data
data
data
empty row
custom table
data
data
data
data
empty row
custom table
data
data
For the spreadsheet below I need code to determine what rows to add for the subtotal for each week for each person listed. The rows will vary each time.
Week: WK1
Visit
Date
OMR
Pay Item
UM
Rate
Start
Finish
Time
Subtotal
10/25/13
GA
RG
H
0.00
35
0.00
Totals for WK1: 0 Visit / 2 Admin
[Code] ....
I am looking for a vba code that will delete rows for me. have data in column E and I need the code to look for any cell that has the word "DELETE" in column E. When it finds the word "DELETE", I need it to delete the entire row. For instance if the first instance of this in cell E41120, then it should delete that entire row and look for the next instance to do the same.
I have seen codes out there to delete rows, but I can't get any of it to work for my situation.