So, We are using Excel 2002 & Excel 2007 and for some reason all of the workbooks that we have open decide to randomly change the fill colours of nearly all the cells. The only reason this is an issue is that a lot of my work envolves me sending reports to clients and from a business perspective this does not look professional at all.
To add to this, once the cells have changed colour, the original colour is no longer available to select.
I have figure A1 column which total amount accounting at cells A31. I need figure 360 as a benchmark calculation perfectly been done. In this calculation 360 well off inside cells A18 although actual number is 363. If we use Conditional Formatting when had enough total in cells the achieve 360, cells colour will be transformed to red. What formula which need I used to change no matter cells on A1 to A30 if sufficient study 360 automatically cells changing colour to red
I need to fill 2 other cells with varying colours dependant on what is chosen within another cell.
I have a drop-down list in cell A2 to select either ON SITE, ACTIVE or CANCEL.
What I need then basically is... if A2 equals 'ON SITE' then fill other two cells (A3 and B1) GREEN if A2 equals 'ACTIVE' then fill other two cells (A3 and B1) YELLOW if A2 equals 'CANCEL' then fill other two cells (A3 and B1) RED
I have a calendar set up with dates going along P6:CU6. Column C9:C27 has various status' for the job such as "Complete" or "In Progress" etc. Next to that in rows D and E I have start and end dates for the job. What I am trying to do is change the fill colour of the empty cells that are in line with each job, so that between the correct dates they are the corresponding colour to the status. So a complete job on row 9 that started on 26/05/14 and finished on 28/05/14 would have three green cells along Q9, R9, and S9.
I have tried an IF/AND/OR statement which looks like this:
I am getting a #VALUE! data type error, I have tried reformatting the cells to various date formats but no luck so far. This could be because my dates are set up as =P6+1 etc. but I am not sure. The error only occurs when the cell falls within the dates, otherwise it remains blank.
I intend to hide the value in the cell and use conditional formatting to change the cell colour based on the hidden input.
Once this is working I also need to take weekends into account, column G has any 2 value combination of Y and N to say whether the employee is working Saturday, Sunday or both. Row 7 has a "1" value underneath every Saturday and a "2" underneath every Sunday. I can imagine how this would work but combining it with the above formula could be complicated.
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..
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.
I have a very basic understanding of excel, I mean BASIC, for my work I have multiple dates for vehicles to go in for inspections. I would like the cells to change colours when within 30 days, 10 days and 5 days. I'm on a work excel 2003.
Situation: Colours randomly change when the following is carried out Change the colour of any cell containing data to any colour (The txt format - not fill) Change to another tab, come back and the colours have randomly changed Turning the bold seems to make this issue greater When selecting a cell(s) to highlight them and changing their colour. The right colour can be seen through the selection. When the selection is de-selected by clicking elsware - you guessed it the cell colour changes again.
I have tried: Insallation fix (Add/Remove programs) Uninstall and restall
I want a cell to be equal to another cell including the colour, conditional formatting as the colour will have no relevance to the cell value i.e. the colour will be set manually dependant on what stage of the lifecycle it is at
The original cell may have a date and be yellow and I want the target cell to be yellow with the same date, if someone then changes the original cell to be red the target cell should automatically change to Red
Is there an easy way to do this or do I need some VB script?
How can I change its colour? Every time I try to it reverts to the automatic black. I do not want to change the automatic colour (not that I know how to) because black suits me for most of the cells; but there are some where I want a blue border.
This problem arose in conditional formatting but applies to ordinary formatting too. It occurs in 2007 and 2003.
Is it possible in anyway to make a formula that changes the colour and boldness of a number depending on whether it is bigger than 50 or 100?
eg. if i enter all my numbers as dark grey. then i enter say, 65, i want it to automatically change to black and bold. if i enter 105, i want it to automatically change to red and bold without me having to do it manually?
I am an Excel newbie and would like your help to develop the attached spread sheet. I would like the colour of cells A4 to H4 to change colour when the date in column B is plus 10 days and the same to happen to A5 to H5 so on and so on
I would also like the cells A4 to P4 to change colour when a quote goes to become an order an we enter data into J4 to P4 again the same thing to happen in subsequent lines as data is entered in the relevant line.
Basically I want a quote of 10 days or more to show as a different colour so that an employee can chase the quote. Once the quote become a firm order I want the cells to become a different colour again.
I'm trying to change the colour of a row based on the value in a cell (in a column) and am wondering how I can do that. Conditional formatting doesn't allow enough colours unfortunatly. Ive googled it and can only get a cell colour to change not a row colour.
To give an explanation:
Sheet 1: Rows 5 - 100 colour to change based on Sheet 2 Column K5-100. Column K5-K100 will have values between 0 and 10.
I m a newbie at Excel but i have a little work project on my hands which i would like to have an excel document have cells change colour to the date
Today is 05/02/08 cells with the attached date of this should be orange Above this date should be green (e.g 10/02/08) and below this date should be red (e.g 01/01/07)
Also after this problem is solved, the dates that turn orange is it possible to automatically have some sort of message come up saying that "Such as such is expiring" or for the red "Such and such is expired" and would the program/document need to be open for the messages to occur?
I don't know if this can be done. When i put on an autofilter in a spreadsheet, and I filter on a particular column, the autofilter arrow is highlighted in blue to show that I have filtered this column. Is there anyway I can change the colour of this indicator from blue to say red?
What would be the quickest and most efficient way of doing the following:
Sheet 1: clicking once, twice, three times in the following cells to change the fill to Red, Yellow, Green respectively (in Row 22, COLUMNS E H K N Q T W Z AD AG) and mirrorring this format/fill on:
Sheet 2: , mirror the selected fill on sheet1 in E22, H22 , K22 in in E3:N3 respectively example E22 (sheet1) is mirrored now in E3 (sheet 2); H22 (sheet 1) is mirrored in F3 (sheet2) etc etc.
I have 35 tabs formatted in the same way - each tab, as with Sheet 1 is linked to a different row on sheet 2 in the same range as is sheet 1 and would need to replicate the mirorring on Sheet 1 to each of the other 34 tabs.
I have two sheets, one sheet showing the total calories burned, in the sheet two, i have the target set,
How can i change the color of cell in the target on the basis of the achivement for example the target is say 10,000 cells and after I achieve 1500, it will change the color, after 3000 it will change another color and so on and so forth.
I have made several Shapes and assigned macros to them, all is good.
What i am curious about: is it possible to highlight or change colour of the shape on press and return to normal if another is shape is pressed? Just anything to make that particular shape stand out that it has been selected then return to normal when another shape has been selected...
That is the code so far that is attached to 1x shape...