Set Background In Cell Depending On Another Cell's Background
In a range of cells (A1..d8) which have background set with multiple colors. Is it possible to set another range of cells (H1..K8) whith the same backgrounds as the other range and so that if one cells background changes the cell in the second range whill also change to that new color?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Set Background Colour Depending On Variants
I need a macro that will change the background colour of a cell depending on whether it equals a certain variant. Let me explain. Cells D8 to N8 will either equal 1, 2, 3 or 4. Depending on the value of the cells on row 8 (D8:N8) I need the above cells on row 4 (D4:N4) to have a different background colour. If the cell on row 8 is 1, the cell on row 4 must have a green background. If the cell on row 8 is 2, the cell on row 4 must have a yellow background. If the cell on row 8 is 3, the cell on row 4 must have a red background. If the cell on row 8 is 4, the cell on row 4 must have a blue background. Therefore, if D8 = 3, D4 will have a red background. If F8 = 2, F4 will have a yellow background. And so on. I need a macro that when ran changes the background colour of the cell range D4:N4 depeding on the value of the cell 4 rows beneath (D8:N8).
View Replies!
View Related
Set Desktop Background
Im designing a desktop background for my office, and want to roll it out once complete. Rather than trying to email the image out and get people to do it manually, is there anything in vba i can do to assist in this? I know its asking a bit much, but ive been surprised in the past with how versatile vba is! (i.e mapping network drives). I asked the IT guys to do it over the server, but they started ranting about screen resolution, priority of other jobs etc etc.
View Replies!
View Related
'Background' Insertion File Size/limiting?
I'd like to insert a picture background for multiple s/ sheets I've developed, however, even though the images I'm using are only 30kb's in size, it bumps my s/sheet file size from 900kb's to over 4mb's ! Is there a way I can stop this from happening, or, any way to restrict the background image to only a certain part of the worksheet as opposed to the entire thing?
View Replies!
View Related
Return Background Color Of Cell
On one worksheet I have a list of colours in cells. I want to be able to look in the list the list and return the background colour of that cell. The function i am using is: =CELLCOLORINDEX('1.1'!$C28,FALSE) '1.1' is the worksheet name, $C28 is the cell (coloured blue) It seems to work because I am getting the correct background colour in the new worksheet, however it also returns the number(37) as well. I just want the background colour to be shown only, not the color's number as well. Function CellColorIndex(InRange As Range, Optional _ OfText As Boolean = False) As Integer ' ' This function returns the ColorIndex value of a the Interior ' (background) of a cell, or, if OfText is true, of the Font in the cell. ' Application.Volatile True If OfText = True Then CellColorIndex = InRange(1, 1).Font.ColorIndex Else CellColorIndex = InRange(1, 1).Interior.ColorIndex End If End Function
View Replies!
View Related
Cell Fill (Background) Colors
when I copy a worksheet from one workbook to another, the colors on the sheet in the destination workbook, become dull/faded. They actually change from the original colors to some off colors. I copy by selecting the source sheet, hold down ctrl key, then drag from one workbook to another). Also, is there a way to get the sheet back to the original colors.
View Replies!
View Related
Customize Background Of A Cell With An Image
I have excel 2003 I would like to identify text cells of my document containing names of speakers in a conference with their nationality. I would like to do that by setting the background of the cell with the national flag of the country where the speaker comes from. I tried to select the flag as an image and put it over the name with trasparency but then it result very not convenient to modify the text in the cell and the image makes the worksheet very heavy
View Replies!
View Related
Cell Shows Black Flashing Background?
When I return to a sheet by clicking on the tab of the sheet, the sheet is not immediately visible. When the sheet does become visible a cell has a black flashing background. Sometimes, but not always, the flashing cell is the activecell. Through the activate event of the sheet I attempt to make $A$1 the active cell:
View Replies!
View Related
Click Button That Changes Cell Background Colour
The problem is that the cells which need to change are locked and have a object group ontop of them and are not all in one row or column.. The cells which need to change are A4,A5,A6,B6,C6,D6,E6,F6,G6,H2,H3,H4,H5,H6,I6,J6,K2,K3,K4,K5,K6. It sort of a theme changer for my spreadsheet incase people want a change and can do all of it with one click of a button or maybe click on a cell with the colour on it and have that colour copy itself to the range.
View Replies!
View Related
Change Cell Background Color Based On Data?
I want to change the color of a cell's background based on valid data in the cell. I have a pull-down list, it uses a named list, and this all works fine. I want the cell to be red, and then after the user selects a valid entry from the pull-down list, I want to change the cell to yellow.
View Replies!
View Related
Conditional Formatting Turns The Cell Background Green With 03
In a column in my spreadsheet i have to input a number; either: 51-61 and next to it is either m or o. so in Column A row 1 : 51m, Column A row 2 60m, etc Example: 51m 51o 55o 60m I want to conditionally format this such that for 51 it turns the cell background green, for 52 red, 53 orange,etc. with a number having a specific color associated with it. 03' does not have a text choice.
View Replies!
View Related
Modify Code To Change Cell Background Color
I have the code below set to change the background color based on certain conditions. What I need to do is change it so that if none of the conditions are met, it does not change the color at all. As it is written now, if anything is entered in a cell that has a background already set, but does not meet these conditions, the cell turns white.
View Replies!
View Related
Macro Button To Change Background Color Of Specific Cell
My boss wants a spreadsheet that has multiple buttons on it that will change the background color of a specific cell to four different colors. Example: Text written in Cell B3, Button in Cell A3 that will change the Background color of Cell B3 to either Green, Yellow, Red or Blue. There will be a lot of buttons on this worksheet following the same format as above. I don't want to change the value of what is in the cell, just the background color.
View Replies!
View Related
Change Cell Background Color Based On Multiple Conditions
My Excel skills are basic at best, with no knowledge of VBA other than finding the VB Editor. What I'm trying to do: Attached is the file I'm working with, to give you a better idea. When a name is selected in column B, the cells in the non corresponding columns E to N should have a black background color. For example, when you select Mike in column B, the cells in that row in columns I to N, named Dave and Dean, should become black. If you select the name Dave, columns E to H (Mike) and M to N (Dean) should become black. In addition, the background color of the non-black cells should change depending on the status. OK : green FAIL: red N/A: orange Exceptions: blue The attached file shows a few possible results, manually entered.
View Replies!
View Related
Making A Cell Change Background Color Based On If Positive Or Negative Sum Total
I have excel sheet with colored cells. Positive cash flow cells all have green background, Negative cash flow cells, all have red background. I calculate all the "sub- total" columns into one "total sum" cell. Based on this "total sum" I want the cell background to be red if the total sum is negative, or green if total sum is positive. How do I make the cell change to the proper background color based on whether it's a negative or postive total sum?
View Replies!
View Related
Conditional Formatting: If A Cell Value In Column X Contains The Word "open", Format Row Background To Yellow
I need to set up some conditional formatting on my spreadsheet, however I am having a little trouble with one of my conditions. The requirement is: - if a cell value in column X contains the word "open", format row background to yellow. - if a cell value in column X contains the word "resolved", format row background to green. - if a cell value in column X contains the word "moved" OR "closed", format row background to blue. Now I have manged the first two on my own, using the conditional formatting tool and using the formula "=SEARCH("open",INDIRECT("X"&ROW()))". However I am stuck on the last one. I tried... =OR(SEARCH("resolved",INDIRECT("X"&ROW())), SEARCH("closed",INDIRECT("X"&ROW()))) However this doesnt work. I tried looking at adding VB script in but to be honest I am not a VB programmer and cant really spend too much time on this. fix the final conditional format so it run if the cell contains either "resolved" or "closed"?
View Replies!
View Related
'shift Cells Right' Depending On Value Of Cell
I need a macro that will "examine" the text of column B for every row checking to see if the text "Proper Text" is in the cell and if not, execute this code for that cell and then move on to perfrom the same until it finds an empty cell: Selection.Insert Shift:=xlToRight Range("B2085").Select ActiveCell.FormulaR1C1 = "Click for detail image" With ActiveCell.Characters(Start:=1, Length:=22).Font .Name = "Arial" .FontStyle = "Regular" .Size = 10 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ColorIndex = xlAutomatic Note that "B2085" above is the cell number that the script stops on to execute this code.
View Replies!
View Related
Graph Background
I'm working on a interfacing program between delphi-excel to manipulate data (from delphi tables) and create a graph in excel. The program is almost done, but I'm having problems with the background and foreground color of the graphs, which don't change.
View Replies!
View Related
Range Copy: Differ Depending On The Active Cell That's Selected
The rows will differ depending on the Active Cell that's selected and I don't know how to specify this. The range I want to copy is from Column B to DA on the worksheet ("Staff") which I want to paste to another worksheet ("Leavers"). This is as far as I got 'FindRemove = lstRemove.Value 'If FindRemove = "" Then End ' Goes to the start of the Data column 'Sheets("Staff").Select 'Range("B4").Select ' Tests current cell against FindRemove 'Do 'If ActiveCell.Value = FindRemove Then 'Call CopyPerson 'Exit Sub 'Else: ActiveCell.Offset(1, 0).Select 'End If 'Loop Until ActiveCell.Value = "" 'End Sub
View Replies!
View Related
Change Background Using A Combobox
I need to change the background of an worksheet using a combobox! Let's say that I have 10 or more picture with different names in folder "C:/picture". I need to change the background of an worksheet selecting this pictures from a combobox. I know that I can do this manually using "format/sheet/background", but I need to automate the process (in "C:/picture" folder, sometimes I will have more than 50 picture).
View Replies!
View Related
Loading Background Picture
I have a dropdown box with a few options in it. What I want to do, is have excel load a particular picture, that I have saved on my computer, into the background when a certain option is selected from the dropdown box.
View Replies!
View Related
Background Text To Be Overwritten
I am trying to create a user form, and need to admit at this point that unfortunately I have no knowledge of VBA - bog standard excel formulae are what I know! I am trying to create a section for people to enter an address, and in itself this is quite straightforward, but I want to be able to enter faint text in the cells as an information instruction that will disappear as someone starts to type in that cell. Can anyone help with a method that would work within Excel versions 2000, 2003 & 2007? (I realise that I could insert a comment, but it's not an obvious instruction, and given the Excel knowledge of a lot of people who will be using this form, it would be completely overlooked!)
View Replies!
View Related
Running Macros In Background
I usually run it on a different server while I work on another available server. However, if I am in Excel on a different server working, I cannot copy and paste in Excel (if I try to copy & paste, I end up pasting data from the macro). This makes sense since the macro is copying & pasting but is there any way around this? I purposely didn't past the code since it's huge but it has a lot of "cells.copy, activesheet.paste, etc".
View Replies!
View Related
Setting Background Colour
I am wanting to create a function, callable from a worksheet, that sets the background colour for any given range of cells to a given RGB value. I am confused about the Color and ColorIndex properties. I'd have thought the following piece of code was trivial and would work but it doesn't.
View Replies!
View Related
Blank Screen Background
I use a number of user forms and would like to dsplay them with a blank background ie not over the top of the spreadsheet. The colour of a blank userform would be nice! I do not want to make them the size of the screen.
View Replies!
View Related
Sheet Background Image As One
I'm trying to put the image in the background by doing 'Format - Sheet - Background' but the image become tiles instead of one. I want the image in the background so I can edit cells with formulas on top of the image. Is there any way of manupilate the background image with Macro so I can have just on image instead of tiles? I've done watermark but that's only available in preview. I'm using Excel 2003
View Replies!
View Related
Lists And Background Colors
I have a list of number (these numbers are related to incidents) and I want to use the numbers as a basis to split of the spreasheet by coloring the rows. There is no order to how many of the same number there is. So, what I would like to do is fill rows with a color based on the numbers. For example. My list (part of it) looks like this: ...
View Replies!
View Related
Multiple IF's And AND Inclusive Formula (all In One Cell) That Would Look At The Above Table And Depending Upon The Price Paid
.............................24............30............36 300014999..........9.00%.......11.00%.....12.00% 1500099999........9.50%.......11.50%.....12.50% 100000249999.....9.00%......11.00%.....13.00% I need an all inclusive formula (all in one cell) that would look at the above table and depending upon the price paid (3000-14999 or 15000-99999 or 100000-249999) and depending upon what monthly term they choose (24, 30, or 36), the appropriate finance charge would be used to calculate a total cost (9-13%). The only way I know to do this is by using IF's and AND's, but there are simply too many arguments and I cannot properly write the formula.
View Replies!
View Related
Macro: Variated Background Picture
My macro generates some graph from some datas. Datas are in some range and when I filtering it shows only filtered values. I use Fixed axis (min and max) because if I use Auto it fit data to the window. My problem is: I would like to use Auto axis because my layout would be better but bacground picture remains the same and it's useless. Background picture should change as I change filters. example: untitled.JPG here is picture: current situation is 1. With Auto axis I get 2. (blue B and green D are filtered results) And I would like to have 3. Is it possible that background picture variate as datas variates?
View Replies!
View Related
Default Background Color Is Purple?
When I open a new worksheet it is purple. The fill color bucket it defaulted to no fill. I select the entire worksheet and click on the 'no fill' and get a normal white background. If I delete anything on the spreadsheet, where the items were deleted the background is again purple. I have to select and again click on 'no fill'. I am constantly fighting this creaping purple. Just started about a week ago.
View Replies!
View Related
Transparent Background Of ActiveX Control
I have an ActiveX Label control with a transparent background. When I click on the label the background turns white and stays that way as long as the mouse is over the label, obscuring whatever's underneath. (It also very slightly alters the character spacing.) What object/property controls this? How do I adjust it? While I'm here, is there an easy programmatic way to assign arbitrary RGB colors to ActiveX controls? The palettes available from the Properties window are fairly limited. A google search for "ActiveX colors" yields a deluge of marketed products, so it's hard to find useful information.
View Replies!
View Related
Forms Button Background Color
Can the backround color on a forms toolbar button be changed or must I use a control toolbar button if I want the button in color? I would prefer using the forms button and have tried customizing (tools/customize/forms) then right clicking on the forms button icon and selecting “Edit button image”, clicked on the desired color and clicked ok.
View Replies!
View Related
Background Color In Column Chart
I have a column chart that goes 0-100%. The back wall is red from 0-60%, yellow from 60-80%, and green from 80-100%. To do this, I shaded some blank cells to the same proportional shape, did a screen capture, saved that image as a file, then imported it back in as the background. Problem is, those color breakpoints (60%,80%) may change, and that process is a pain. Is there an easier way to do this such that if I change the values the background will change automatically based on the shading of some cells?
View Replies!
View Related
Isolate Sheet Background And Grid?
How can I set up my sheets so that the background and grid are isolated, in other words only the background, the grid, and my data shows on the sheet, the rest will be blacked out. I need to email only the certain area of the worksheets.
View Replies!
View Related
Worksheet Background And Font Colour
when i pasted the data into an Excel sheet, the background will change to red and the font will turn to blue. Besides, the font in header will change as well. I can't find the way how to do it because this template is set by other person. I can confirm this is not done by macro.
View Replies!
View Related
Cells Over Background Image For Printing
I need to set a background as an image, but retain the cells so I can type in them individually (not using text boxes). This template will be used for automatically generated daily reports, so the cells have to be present. How can I retain the rows and cells as they are, but set an image behind them? Note: This isn't the header part of the header and footer, but the top of the document.
View Replies!
View Related
Clear Background Color Before Print
I have a excel file wherein background color as well as conditional formatting background color is used. However, since printout consumes huge ink for those sheets, i want that before print the code will clear all the background color (done through Fill color & conditional formatting color) and after the print activity, restore those color. the colors are given to faciliate data entry and better presentation.i have recorded the same but background is not restored when I run the code And also sometimes the code doesnot start printing.
View Replies!
View Related
Background Color And Border Around Macro
I am trying to develop an Excel spread- sheet by using some macros. In detail, in my first worksheet, I have something like - Exp1 .... Exp2 .... Exp3 .... : : : Expn .... This rows are coming from another worksheet and I have used a macro (developed by me) to populate these rows. Even the number of rows to be populated is not fixed. However, I would like to add one row with text - " Total Expense" after those rows. This row will have some background color - say Tan - and font color - say Green - and also a border around its own - in nature, the border will be thick, Double and with color Rose. I have tried the following code in macro but not working properly - Sub Include_Fields_n_Format(loc As String) tot_exp_scell = loc & f_scell tot_exp_ecell = loc & (f_scell + 1) Range(tot_exp_scell, tot_exp_ecell). Merge Range(tot_exp_scell, tot_exp_ecell).WrapText = True Range(tot_exp_scell, tot_exp_ecell).Interior.Color = RGB(150, 150, 150) With Range(tot_exp_scell, tot_exp_ecell).Font...................
View Replies!
View Related
|
TRACKER
