colour

Is there a way to conduct a countif function where it only counts the cells that contain a colour or counts all cells but deducts the number of cells containing a particular colour, grey for example. ie in cell e19:f19 (merged cells) I want to count the number of cells that do not have the fill...

I am using excel 2003 but the boxes are there that offer me the colouring facility? I have produced a number of boxes by using the border style in format cells. There is a box in the border cells page that offers me the chance to colour the border. If I click on it and turn the box red, for...

I need COLUMN A to sort all duplicates to the top IF one of the duplicates contain a cell with a specific colour. Example: <tbody> 234632498523 2523242237 8834523526 777777777777 24454784568 33333333333 CELL COLOR: YELLOW 573423452345 777777777777 CELL COLOR...

Hello all, I'm working on a database, and I have it set up to automatically pull unique values from the one column. I use these unique values to populate a dropdown menu so I can sort the entries easily. The formula I have works for most things, but occasionally I'll have a cell that needs...

Using Excel 2000 Hi, I need VBA to get coloured 0 as shown in the example below <colgroup><col></colgroup><tbody> 0 | 0 | 0 | 1 | 1 | 1 | 1 0 | 0 | 1 | 1 | 1 | 0 | 1 0 | 0 | 1 | 1 | 1 | 1 | 0 0 | 0 | 1 | 0 | 1 | 1 | 0 0 | 0 | 1 | 1 | 1 | 1 | 0 0 | 0 | 1 | 1 | 1 | 0 | 1 0 | 0 | 1...

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...

Is it possible to apply a fade from one colour to another on an active x command button?

Hi all, I have tried many ways to do this and have given up. I have a few customers and I have the spend for each month and I was trying to get the text to highlight if the spend is less than the previous month (if that makes sense). I have typed how it should look (I have manually changed the...

I have this code that manipulates the appearance of a label in my user form. With .Controls(hfg & "_en") .BorderColor = RGB(51, 204, 51) .BorderStyle = 1 .ForeColor = RGB(51, 204, 51) End With The RGB is a shade of green...

My macro steps through a table, the last step is to colour the row based on some criteria. At the moment it uses For Each product in Range ... If product.Offset(, 15).Value < 0 Then With product.EntireRow.Interior .PatternColorIndex = xlAutomatic...

I'm trying to use a conditional formatting formula to colour a cell if the date it contains is a saturday or sunday. I actaully need to do a whole column of 31 cells on 12 sheets but i can't even get one to format. I'm using this for the formula to try to colour A11 which is a saturday...

Could someone advise how to format a cell with conditional formatting based on another Cells colour? Or could someone point me in the right direction for learning this as a macro? Thanks

Hello, Long time lurker - thanks for all the great solutions and tips that I have harvested from this forum so far. My question is: Is it possible to use use the IF function to react to whether a cell is shaded, and shaded a certain colour? Context: I have a budget template document with...

I am trying to apply conditional formatting to a range of cells, whereby formatting is only applied to those rows with an "x" mark in a column, and second only for a range of columns (e.g. rg2) I have tried the following code, but haven't been able to combine the column and row selection. I...

Hi I have set up automated timeline (Gant Style) workbook for colleagues whichworks fine but they have now asked me if I can have the bar colour changeautomatically if a task is past due e.g. Green while it is in scope and redwhen it is Out of Scope. This is not something I have been asked for...

Morning, I have a list of 35 shops and their sales, the chart updates weekly and the list of shops re-orders according to their sales position The ordering of the shops is based on a formula, using the LARGE function Some of the shops need to have their data point in a different colour. Up...

Hello,</SPAN></SPAN> I have 3 different scenarios for that I need 3 separate different codes to colour them as shown below</SPAN></SPAN> Scenario-1 Columns C & D colour all case occurred more then 1 time continuously like H=2 times & 3 times, 9=3 times and 25=2 & more times</SPAN></SPAN>...

Using Excel 2000</SPAN></SPAN> I got data in the column C (A, B, C, D and E) separated by vertical bar and there is a one space between vertical bar also that I want to coloured all different colour but each alphabet must be the same colour in the below example there are coloured only row 5 & 6...

Hi All, I am looking to compare 2 data sets and identify any differences using colour. I have demand from a customer and want to compare against an internal demand book. I have created data set to test this. I have added 2 data sets into a simple table with one column identifying data source...

Hi I have a spreadsheet that colours cells yellow if they have a duplicate name listed in next column as the column is long (500 rows)I was hoping that there was vba code to copy the small number of cells with fill colour and automatically paste them in another column so i can see them quickly...