cell colour

Hi I have a work book where on sheet 1 I have a lot of data where I have highlighted different cel with text in different colours, On sheet 2 I have set for certain colums from sheet 1 to copy across using the generic ='sheet1A1' function, I also want the cel colour to transfer with this but...

Hello. I hope someone is able to help me. This seems simple (and I'm sure it is), but I cannot work it out. I have 2 columns of figures (A and B). I want to highlight in red the cell (A2) in column A, if "B2 divided by A2 is less than 1.1 or greater than 2". So in the example below, A2 and A5...

I wonder if some one has a tip on how to solve this conditional type formatting problem. I want to color each cell based on if the value has increased or decreased from the value immediately below. If the value is following a trend the color will get darker, so based on the values of column B...

Is there any formula in excel to get the sum of specific cells by its background cell color. Example I need to get the sum of cell values which have Orange backgroundg color ( eg. 100, 400 & 300 ) Return value should be 800. 100 200 500 400 300 50

Hi all. I want to conditionally format a cell. The cell at the moment has in it the calculation of a weighted average in it from four cells above it. I want the cell to be formatted red if the four cells from which it calculates the weighted average from are blank. Yellow if at least one of...

Hi All, I am currently setting up a file for my new department I have just joined. They are looking to make their excel documents more automated to save time. One of my current tasks is to change cell colours depending on what is contained within the cell. I can easily conditionally format the...

Hi, I have a spreadsheet of information with some VBA code attached to it. Within the spreadsheet are two columns A & B, column A will either be blank or contain "COMMS" and column B will be the same either blank or contain the value "COMMS". I need some VBA code that will do the following...

Hi, I'm relatively new to Excel, but I'm currently working for a construction company in planning the start and finish dates, and just general progress for their construction projects. I'm currently working off of very basic spreadsheets, where everything is entered manually. I know I could...

Hello all I have 2 worksheets and I need the colours in cells one sheet to change depending on the entries in another sheet. The formulae in sheet 2 would be something along the lines of If Time in Cell A1 is before 9:30 and Cell D1 and D2 are equal to D4 then cell in Sheet 1 is Green. OR...