background

Hi, I'm trying to set up a macro (attached to a button) that will do two things when clicked: - change the print area - change the font color in certain cells to match their background color. I have the code for changing the print area, but don't know how to get the other part. Basically...

Super new here, but I've been dabbling with Excel for a couple of years. I've been tasked with creating a group sheet. Clicking 1 of 5 buttons will automatically color the background of a cell, according to the button clicked, if I enter 1 of the 6 identifiers. This is the kind of flow I was...

Hello, Here is my situation: I have small sheet using conditional formatting to automatically fill the background of empty cells in a row if a value is entered for other cells in the same row. This is a request form type of spreadsheet and we want to basically force our employees to fill all...

I can't find a way to allow a pdf file I open within Excel to open in the foreground in front of Excel. It always opens in the background behind excel workbook. Is there a way around this either by making PDF open in foreground or excel go to background when the pdf opens. I'm not sure if it's a...

hi i had some code but cannot find anymore can someone help on this:- c3:c1000 has a cream background colour and will sometimes have data entered when the cursor is moved up and down G column i would like the corresponding row in column C to highlight purpose so can identify the correct...

Hi all, I have an image with a transparent background that when I insert it in Excel, I still see the transparent background. Is it possible to hide the checkered background? Thanks.

I believe I would like to create a ToggleButton. With my limited development background, I believe I want to layer an invisible togglebutton over a cell, so that the user, when they click on the cell will change the visual properties between three states: TRUE - green background with...

How can I make this- if A1 cell data is "INH" then G1 to N1 cell background color will be Black

Hi All, Is it possible to do the following: Change the background colour of a cell based on the background colour of a cell on another sheet. I would like to have 4 pages all linked together whereby if i change the background colour of a cell on the master sheet (B12 for example) then the...

Hello, I have a userform which Height"1080" , Width"1920" and with below code when its populated if I run the whole code, the background picture doesn't fit at the screen even though picture size is 1080*1920. The reason of that size is I'm going to use that userform at the big screen tv. Is...

I have current code to change the background of the cell I updated "Today" to the color of the day. Today is the 15th of the month, so todays color is 15. What I am looking for is the "15" to change based on the day, so tomorrow the code would change to 16 without me going into the code daily...

I have a scrollbar whose values will be between 0 and 5 I would like to illustrate the value by having the background to the slider change colour - effectively 'fill up' There seems no default way to do this So I was going to make the slider cover 5 cells and set a conditional format for each...

Hi, I am attempting to paste several overlapping images into a cell. The process works perfectly until the third image is pasted, because Excel seems to want to offset any subsequent images by increasing amounts. If that is not quite clear, I have a sheet that contains 10 images: 5 backgrounds...

Hello, I've searched online and not had much luck trying to find a solution for this. I am not an Excel expert and do not know VB so I was trying to use conditional formatting to format a cell based on another cell's format (fill color)... Find cells in range K5:V5 with fill color green [I...

hi working with Excel 7. seems all sheets have black background, with white fonts. It seems to be a default, in all workbooks. I'm trying to change the background to white with black fonts. using the fill icons does not do anything. how can i make the change in colors, and keep them as...

Hi Guys, I have been chasing my tail on this one. I have a chart and I want to place a "label" on it using a textbox. I need to make the background of the textbox white and the text black. here is the code I have. Sub Sticker() With...

I would like to change the text colour used for formatting a cell based on the background colour of the current cell i.e. I want to set the text colour to be the same as the background colour, essentially making the text in the cell invisible. So whatever the background colour for a given...

Hello everybody. I've set a dropdown list this way: Dim MyList(2) As String MyList(0) = "YES'" MyList(1) = "NO" Dim lrut As Long lrut = sheet1.Cells(Rows.Count, "E").End(xlUp).Row With Range("G2:G" & lrut).Validation .Delete .Add Type:=xlValidateList...

Hi folks, In Column A1 to A10 each cell has a different number.However if two numbers are the same I want to colour the background a certain colour(lets say green). If 3 numbers are the same the backcolour will be red and if 4 numbers are the same the number will be purple. Is this possible...

Hi, Column A has 1000 rows and Column B is 3000 rows. I am trying to write VBA to search column A value in Column B. If found then change the background of column B yellow otherwise green. Any help, please.