background

Hi Mr Excel, I would like to ask a new favor from all of you who may have encountered this: It goes like this: -> =IF(D4>=D3) background is yellow -> =IF(D4<D3) background is red -> =IF(AND(D5>=D3,AND(D5>=D4) background is yellow -> =IF(AND(D5>=D3,AND(D5<D4) background is blue And so on...

Everytime I run access query. My Access database screen freezes. Is there anywhere I can let Access query run in background and close the database and open it later to see if the query is ready?

Hello everyone, I have inserted a stock excel icon (a computer screen). When i attempt to print the sheet, the right side of the icon is not showing up. I've tried to bring it forward and bring it back, but to no avail. It does not make a difference where i place the icon or what color the...

Hi All, I am trying to figure out a way that I can apply a background colour to a range of cells (which will change on a monthly basis) based on the colour of the previous range of cells. So, if the previous range of cells is coloured green, I want the new range of cells to be coloured red...

I have a sheet where I inserted a map as a background image. I put information in various cells based on their proximity to the map. Works great - on my machine. A coworker opened the same file on his machine and the background image scale was different in relation to his cells (I'm guessing...

Hi, I was curious if there is a way to use a png or some other image file type that allows semi transparency for an image background in a label or frame or some userform tool. Thanks!

I have a macro that copies the formats from a top row of data to the end of the data. I have started to highlight certain data with different background colors which I do not want to lose. Is there a way to copy formula (number formats, date formats, column alignments, fonts) but not the...

Hi Guys I have various lists consisting of 3 columns; some rows are coloured (only 1 colour); and others have a plain background. I'm trying to separate this data into 2 separate lists - one showing the filled data and the other showing the data with a plain background. What is the easiest way...

Need macro to change background color of four ranges (Q5:Q7, T5:T7, Q32:Q38, T32:T34) to RGB 250,250,200.

Evening, I have a question for you guys and girls. I am working on a chart that looks like this: https://s7.postimg.org/puskz7m5n/Untitled.png Now my question is: Can the chart plot background be split into a 3 colors depending on their value? I have 3 different criteria 0 - 25000 -...

I am in the process of building a couple of product generating spreadsheets, for personal and corporate use. I'm currently working on a XY Scatter chart generator that looks at sales distribution or different product, across different areas. The generator itself is fairly simple, and is...

Hi, I hope someone can assist with an odd issue I'm having with Excel 2016. I've just updated to version 16.0.6965.2092 and for some reason it affected the look of my quick access toolbar. I have around 70 macros on my QAT. The ones that are visible are fine, however, the ones that spill over...

Hello, How can I set a background base on the user selection ? If the user select from A1 to d1 and then click in the yellow(b5) background will turn to yellow(B5) if the user click in the red (B6) background will be red. Thank you!

Background Info: I inherited an excel doc (.xlsx format) and am using Excel 2010. There are NO conditional formatting rules in the entire workbook, nor is it protected. All of the values do seem to be copy & pasted from a different workbook though. I say this because there are almost no...

Hello. I am tracking multiple sheets to when people answer the specific questions. I have tried to use a VBA but have been unsuccessful with it. Below it the VBA I used, and what I am trying to do. Function GetColorCount(CountRange As Range, CountColor As Range) Dim CountColorValue As Integer...

Hi all, Just a quickie I am trying to get a cell background colour (or font colour ) to change based on the value of another cell. The cells in question are as follows: B2 - Cell colour to be changed H20 - Cell to get the reading from Here's what I'm trying to get to work If cell H20...

This might be simple one but I don't know it. On the sheet1 tab I have the range A1 to A5 that can have any numeric value. Along with the number, they may have a different cell color background other than the white color. sheet1 A1 3 A2 3 A3 3 (with yellow cell background) A4 3 A5 3...

I have a excel workbook with a 7 sheets of data, this workbook has been created using MS office 2008 & 2010 packages. When I try to open this document in my team leads system it has automatically opened in green color background and few columns text as red color, but the same time when we try to...

I'm looking for a formula that adds up the all the values beneath the given cell until a cell with a different background color is reached. Example: <tbody> 35 (Sum following until background color changes) 5 (Yellow Background) 10 (Yellow Background) 12 (Yellow Background) 8 (Yellow...

I have a signature form on a tablet that takes the input strokes and then displays them as a picture object (as opposed to an ActiveX shape, which I try to avoid because they can drastically slow down the underlying code). A second technician can add his signature by opening the form, which...