Remove Cell Colour Before Printing

Mar 16, 2009

I have a spreadsheet which is to be filled in by multiple users, in order to assist the users I have colour coded, and left unprotected, the cells that they need to interact with. I really don't want them messing with the formulae!

However, when a user chooses to print the sheet I would like the coloured cells to be printed in B&W.

I have a very little VBA knowledge - I know I need something to follow 'Private Sub Workbook_BeforePrint ()' or at least, I think I do!!

View 9 Replies


ADVERTISEMENT

Remove Hyperlinks Without Changing Background Colour Of Cell?

Apr 20, 2012

how can I change the following code so that the cell background colour remains the same. the below code unlinks the hyperlinks but deletes the backgroundcolour also of all the cells.

Code:
Private Sub Button3_Click()
ActiveSheet.Hyperlinks.Delete
Range("A7:W100").Select

[Code].....

View 1 Replies View Related

Printing / Not Printing Ranges Based On Cell Contents

Apr 11, 2008

I have a report that is generated from a manufacturing process that looks like the example below. the report is 40 pages long when all the data is printed. i am looking for a way to only print this range if a dimension is "out of tolerance". if the dimension is within tolerance, there is always the "garbage" text of plus and minus. if every row is "within tolerance" in the range the cells in the OutTol column would all contain the "garbage" text but it will not always be identical. so, in summary, actual OutTol values = print and all "garbage" = not printed.

NomActDevLoTolUpTolOutTol
Y-0.956-0.9480.008-0.0030.0030.005
Z-1.413-1.4130.000-0.0030.003---*|++++
DIA0.4220.4240.002-0.0030.006----|+*++
POS0.0160.0110.005

View 9 Replies View Related

Colour Data Points On Chart From Dynamic Cell Colour?

Oct 3, 2012

I would like it to loop through all the charts on the "Graphs" sheet.

It works well but gives a "Run-time error '1004'" Application-defined or object-defined error afterward that I would like to get rid off.

VB:
Sub Colour_Chart_working()
Dim rngColors As Range
Dim rngCell As Range

[Code].....

View 1 Replies View Related

VBA Code To Colour Certain Cells Based On RGB Colour Shown In Cell A1

Apr 17, 2014

I have a lookup that gives and RGB colour code in Cell A1; for example 186, 206, 140.

I'd then like Cells R10:V15 to fill with the RGB colour based on the result in A1.

View 2 Replies View Related

How To Make Arrange Colour Equal Cell Colour

May 23, 2014

A column of cells can be 1o different shades of green according to their value (achieved by using conditional formatting.) I want to arrange that at a certain time all the cells of a part of the row of a formatted cell are the same colour.

View 4 Replies View Related

Excel 2010 :: Remove Gridlines And Customize Background Colour Other Than Table

Mar 8, 2014

Is it possible to remove all gridlines (except in a table) and change the background colour to plain colour (except the table) in Excel 2010?

View 2 Replies View Related

Printing Multiple Workbooks With Printing Preference As Landscape

Jan 15, 2012

I would like to know if there is a way to print several different workbooks at once but keeping my printing format which I would like to be Landscape and Fit to one page. Reason is simple as I work in a office where staff is handed in several jobs to do everyday. They finish the jobs and log all the info on the database. I log on to database and put all their daily diaries and because it is all over the place I have to go in each file and set printing preferences which takes an hour in the morning and hour in the evening. I could do with some sort of automation where all diaries are automatically printed in Landscape and Fit on one page.

View 2 Replies View Related

Search Excel For Cells With Numbers Of Certain Colour And Changing Said Colour

Feb 13, 2014

Is it possible to search Excel by cell colour, i.e. font colour...and then change the said colour to another one?

View 3 Replies View Related

Printing Cell Comments

Jul 8, 2009

I have several worksheets that have comments in the cells. Most of the comments i have set to "un-hide" and they can be printed. I now have this one spreadsheet where no matter what I do I cannot print the comments.

I must have something turned on or off but for thwe life of me I cannot figure out what it is. I can see the comments on the screen but when I go to print preview they are not there.

View 2 Replies View Related

Printing Cell Borders

Jun 20, 2006

I have designed a form with Grey horizontal borders.

When I print to my HP LaserJet 2420, the borders are black.

I have other forms with Grey borders where the borders print Grey.

I have not chosen to print Black and White in Page Setup.

How do I correct this?

View 6 Replies View Related

Excel 2007 :: Get Cell To Refer To Date That It Contains And Change Cell Colour Based On That?

Dec 19, 2012

I work for a UK charity and have a list of funders in an Excel 2007 spreadsheet.

One of the columns refers to the date on which a new application for funding can be made to that particular funder.

In many cases new applications for funding can't be made for 1 or more years since the last application - sometimes as many as 5 years later. How to get a cell to refer to the date that it contains.

For example, say I have in cell A1 "The Acme Funding Organisation" and in cell B1 (i.e. the "Reapply when?" column) a date of 01/04/2013 (British date format, i.e. 1 April 2013) then what I want Excel to do is to look at the date in cell B1 and if that date has been reached to highlight the cell red. That way I'll know that the reapply date has been reached & that a new application can be made.

View 2 Replies View Related

Excel 2010 :: Change Colour Of Cell Based On Date In Other Cell?

Jan 10, 2013

I am trying to create a sheet in XL 2010.

In Column A each cell will contain a date (differnet from other cells in that column) when inspection was last done.

Column B is when the weekly inspection is due.
Column C is when bi-weekly inspection is due.
Column D is when monthly inspection is due.
Column E is when 6 monthly inspection is due.

I need a formula to change the colour of cells B, C, D & E when each inspection is due depending on the date entered in A

I am hoping its possible that the cell colour can stay for 2 days after the due date and then return back to blank after the second day.

For example if cell A1 has a date of January 1 2013 then on January 8 2013 cell B1 turns red then on January 10 2013 the cell returns back to normal.

A1
B1
C1
D1
E1

Inspection Date
Weeekly Due
Bi-WeeklyDue
Monthly Due
6 Monthly Due

January 1 2013
Change red Jan 8 & return blank Jan 10
Change red Jan 15 & return blank Jan 17
Change red Feb 1 & return blank Feb 3
Change red June 1 & return blank June 3

Ive also attached the worksheet

View 1 Replies View Related

Hyperlink Cell To Filter That Cell Value Based On Colour Filters Used In Another Sheet?

Aug 5, 2013

I have a table which says that this is the amount of coloured cells we have in another sheet.

For e.g.

Field Name Code A
Item Description 5

Now, the item description column has 5 cells in another sheet which are filled in with "Yellow" Colour. So what i want to do is to click on this 5 in sheet 2 in this case as per the attached sample which takes me to the filtered result on sheet1 of 5 yellow coloured cells under the column of Item description including an additional filter of Code "A"

View 1 Replies View Related

Excel 2010 :: Change Cell Colour Depending On Date In Another Cell

Jan 9, 2013

I am trying to create a sheet in XL 2010.

In Column A each cell will contain a date (differnet from other cells in that column) when inspection was last done.

Column B is when the weekly inspection is due.

Column C is when bi-weekly inspection is due.

Column D is when monthly inspection is due.

Column E is when 6 monthly inspection is due.

I need a formula to change the colour of cells B, C, D & E when each inspection is due depending on the date entered in A

I am hoping its possible that the cell colour can stay for 2 days after the due date and then return back to blank after the second day.

For example if cell A1 has a date of January 1 2013 then on January 8 2013 cell B1 turns red then on January 10 2013 the cell returns back to normal.

A1
B1
C1
D1
E1

Inspection Date
Weeekly Due
Bi-WeeklyDue
Monthly Due
6 Monthly Due

January 1 2013
Change red Jan 8 & return blank Jan 10
Change red Jan 15 & return blank Jan 17
Change red Feb 1 & return blank Feb 3
Change red June 1 & return blank June 3

View 3 Replies View Related

Formula To Change Cell Colour :: Shade A Cell Depending On Condition

Feb 9, 2007

Is it possible to use a formula to shade a cell dependent on a condition? I have tried an if formula (see below) but it is incorrect. =if('November 2006 SVOC'!B6>'March 2006 SVOC'!C6,'November 2006 SVOC'!B6 [red],if('November 2006 SVOC'!B6<'March 2006 SVOC'!C6,'November 2006 SVOC'!B6 [blue],))

View 3 Replies View Related

Change Colour And Values Of Cell Based On The Value In Adjacent Cell?

Nov 10, 2012

I need to write a condition in such a way that cell IF A1= "DBR","BPR","SLR","SKR" then change cell B1 to SPECIFIC COLOUR Each condition different colour. A1 values ("DBR","BPR","SLR","SKR") is a list of selectable values. if the condition is falls then B1 should be normal (white color cell) with 0 in it.

View 1 Replies View Related

Colour Cell Based On Few Conditions / Cell Values Of Other Cells In Same Row?

Jun 28, 2014

In the xls for each step I have 2 raws-planned and actual. Step planned duration is populated manually over the weeks.Before that row we have another reflecting the actual step status per week

I would like to find a way how cell reflecting the actual status of a step can be automatically populated (coulored) based on the colour/value of activities that are planned for that week and for that step.Activities are listed below the step and again have planned and actual row.

The rule should be : if for a week we have several activities all of them should be finished in order to have step stataus auto populated as green. If a single activity planned for that week is not done-then weekly step status should be red.

The activities for each step are grouped below the step. It seems that one of the difficult part in that request would be how formula will understand where starts and finishes the activities that belong to one step. To get that happen I placed a column showing step and another column where we activity.

View 9 Replies View Related

A Cell Colour Based On 5 Other Cell Colours That Have Been Conditionally Formatted

Jun 30, 2009

Using 2007, I need to conditionally format a cell colour based on 5 other cell colours that have been conditionally formatted. The 5 other cells will be coloured either red or greem. What I want to do is have an overall status cell that would be show green if all of the other 5 cells were green, amber if 4 of the other cells were green and one was red and red if 3 or more cells are red.

View 4 Replies View Related

Format Cell With Colour And Boxsurround If Cell = "Clos

Feb 6, 2007

It is possible to add something in a spreadsheet VBA to colour a cell Green and put a box surround on it if the cell = "Closed" from A7:V65535

Basically I have four conditions for status of a task and i can only use 3 formats on conditional formatting so i need some code to format the last remaining status type which is "Closed"

Got this part of code to make it the correct colour

With Selection.Interior
.ColorIndex = 4
.Pattern = xlSolid

View 9 Replies View Related

Removing Cell Values When Printing

Dec 20, 2006

I am working on a form right now for a shipping company in MS Excel. Anyways, I have a few cells formatted as text that have a starting value of "[Insert Comments Here]". What I am trying to do is have it so that IF the cell has the original value "[Insert Comments Here]" upon printing, THEN the cell's value is changed to "" or some other way of not making it print.

I would like to be able to do this both with cells and the "Label" form objects.

View 9 Replies View Related

Prevent Data In Cell From Printing

Feb 4, 2010

i have data in a cell that i must view in the sheet and in the print area
but do not want it to print

View 9 Replies View Related

Auto Numbering Cell While Printing

Sep 9, 2006

Looking for a way to print out a worksheet with auto number while printing. The worksheet does not have a header or a footer and contains needed information.

View 4 Replies View Related

Colour 7 Cells In A Row And Then Switch Colour?

Jul 17, 2014

So I have a macro that colors the selected cells in a certain color. Now im looking for a code that will switch that color every 7th cell, the cells will only be selected horizontally. For example:

if the selected range is 10 cells, 7 of them should be in one color and 3 of the should be in another. But if the selected range is 15 cells the first 7 should have one color and the next 7 should have another and then the last one should have the first color again, and so on..

View 6 Replies View Related

Changing Cell Fill Colour Based On Another Cell Value

Oct 2, 2008

I have a table:......

I want to colour in the relevant cells for each ref depending on the numbers in the stage column. So for the first line, the cells in columns 1,2,4&6 need to be shaded in. For the second line, the cells in columns 1,2,3,4,&5 need to be shaded in. I already have a lot of conditional formatting set on the sheet so need to do this with a macro.

I have tried to write something but am having issues with it finding the 1 and shading in the correct column but then jumping out of the loop and on to the next cell.

View 4 Replies View Related

Formula To Change Cell Colour :: By Value Of Cell In Another Sheet

Sep 30, 2008

I need to set a cell colour by the value of a cell in another sheet so i can't use conditional format. Is there a formula that allows the user to set a cell style, colour, font etc.

View 9 Replies View Related

Cell Colour Change From Result In Adjacent Cell

Jun 1, 2006

I am trying to make the colour of cell change depending on the result in an adjacent cell and have found and adapted the following:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim icolor As Integer
If Not Intersect(Target, Range("x4:x202")) Is Nothing Then
Select Case Target
Case 11
icolor = 43
Case 21
icolor = 43
Case 31
icolor = 27
Case 41
icolor = 27................

View 4 Replies View Related

Colour To A Cell

Mar 22, 2007

Below is a formula i am using on a spread sheet. What I would actually like to do is instead of the cell showing "OOS" if the statement is false, I would like it to show Z11 but in bold red so it stands out.

=IF(AND(Z11>=35,Z11<=45),Z11,"OOS")

View 9 Replies View Related

How To Tell Cell To Get The Colour Of Itself

Jan 23, 2008

I am using

Range("E9").Select
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
End With

This colours the cell that colour (36) how do I say to take the colour in the cell already?

View 9 Replies View Related

Printing Number Of Pages Based On Value In A Cell

Nov 20, 2006

simple example.

A1 = 155
I need to print 3 pages where B1 is equal to 50 and 1 page where B1 is equal to 5. A1 may change, but B1 will always be multiples of 50, plus whatever is left over.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved