Colour Numbers
Oct 18, 2009I am having a bit of trouble specifying the colours I want into my VBA code.
Please see below
ADVERTISEMENT
Search Excel For Cells With Numbers Of Certain Colour And Changing Said Colour
Feb 13, 2014Is it possible to search Excel by cell colour, i.e. font colour...and then change the said colour to another one?
View 3 Replies View RelatedColour Data Points On Chart From Dynamic Cell Colour?
Oct 3, 2012I would like it to loop through all the charts on the "Graphs" sheet.
It works well but gives a "Run-time error '1004'" Application-defined or object-defined error afterward that I would like to get rid off.
VB:
Sub Colour_Chart_working()
Dim rngColors As Range
Dim rngCell As Range
[Code].....
VBA Code To Colour Certain Cells Based On RGB Colour Shown In Cell A1
Apr 17, 2014I have a lookup that gives and RGB colour code in Cell A1; for example 186, 206, 140.
I'd then like Cells R10:V15 to fill with the RGB colour based on the result in A1.
How To Make Arrange Colour Equal Cell Colour
May 23, 2014A 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.
View 4 Replies View RelatedColour 7 Cells In A Row And Then Switch Colour?
Jul 17, 2014So 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..
Colour Rows With More Than One Colour
Nov 24, 2011I'm creating a worksheet which tracks pupils progress in our school. down the left there is a column to put in the level they came into our school on - eg 1C or 3B etc.. to the right of the level is a colour coded row which shows Pink, Yellow and Green - if the pupil makes it into the green part of their level by the time they leave then they are on target.
Basically I have a column of cells which use a data validation list which is linked to another sheet with a list of levels. What I want to happen is when I select the level - it fills the row to the right with the correct colours.. I've attached a picture to show you what i'm trying to do.
Reason being is - we might have 6 kids on L3, and 1 on L1 so the number of rows needed for each level changes - at the moment I'm having to copy and paste - which although is easy enough, it is a bit tedious when you have a whole bunch of pupils to put on the grid.
I can't find the option in imageshack to use a thumbnail
Changeing A Cells Colour Basing On Other Cells Colour
Mar 23, 2009i want a cell to change to the colour green if 5 other cells on the page are green colour.
I want a cell to change colour to red if there are 1 or more red cells on the page.
How do I make this work?
Chanage Autoshape Colour According To Autoshape Colour In Another Worksheet
Oct 23, 2008I am trying to automatically change the colour of an oval in worksheet1 to the colour of oval3 in worksheet 2.
Currently oval3 (Worksheet 2) has the a vba code that changes its colour when you click on it.
Cells Colour Equal To Another Cells Colour
Jul 19, 2012I 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 To Add Colour In Column
May 27, 2014I'm trying to add colour in column E5, yellow after 34 months from the date in D5 and then red in the same E5 after 36 months. Is it possible?
Then if the date in D5 is updated, I want E5 to become white again.
Colour Code
Aug 10, 2009I have created a Sales Data spreadsheet which is updated by 10 members of our sales team. We also have a master sheet which gets updated the moment the individual sheets are updated by the sales team.
I want to know how I can differentiate the new entries with the old ones. Is there a code I can insert in the Master File which would change the colour of the new entries, say for example, all the rows with the date field “August” should automatically be changed to yellow. Similarly all “September” entries should automatically be coloured Red.
How To Use Colour Indication
Mar 20, 2013There is one Excel file and data is filled in two sheet. I filled first sheet having a unique ID (23,25,26,27). same unique ID will be enter in second sheet. So i want that when i will enter any unique ID in second sheet then on first sheet complate row should chage in green colour for same unique ID.
First Sheet
23asin
25adout
26aeout
27afin
Second Sheet
23
26
27
Colour Macros
May 11, 2007i have a matrix with all possible values.
i need to develop a macro, which will change the color of the cell according to the value of the cell.
for example if a specific cell in the matrix has a negative value then the macro should change the color of the cell to blue. if its value is positive then the macro should change the color of the respective cell to red.
Sum Based On Colour
Oct 16, 2008i'm currently using some VBA code to insert a formula and sum certain rows. Which rows to sum is determined by the following line...
View 5 Replies View RelatedBackground Colour
Dec 18, 2009I have to codes which work
View 3 Replies View RelatedColour To A Cell
Mar 22, 2007Below is a formula i am using on a spread sheet. What I would actually like to do is instead of the cell showing "OOS" if the statement is false, I would like it to show Z11 but in bold red so it stands out.
=IF(AND(Z11>=35,Z11<=45),Z11,"OOS")
SORTING BY COLOUR
Nov 2, 2004Some silly twits in my organisation think they are being helpful by highlighting lines of excel and then expecting me to sort on it - how do I do this without going through every line - is there a way of returning the format value of the cell including the colour / background colour ?
Some random emoticons for you to look at while you consider...
:hungry: :warning: :wink: :roll: :lol: 8-)
Delete By Tab Colour
Nov 26, 2006how i can delete this selection by tab colour?
Thought it would be somthing like this.
If Worksheets.Tab.ColorIndex = xlColorIndexNone Then
Rows("1:11").Select
Range("D1").Activate
Selection.Delete Shift:=xlUp
Change The Colour
Nov 29, 2006condition: the cell in row K and row L can only have value 0 or 1
if cell in the column K & columb L = 1
then both cell is green colour
if cell in the column k column L
then both cell is red colour?
taking example if k1=L1 =1 then is both green colour
if k1 =1 and L1 = 0 then both are red colour
RGB Colour Index
Nov 30, 2006I am looking for some assistance on RGB colours.
I have a spreadsheet with cells shaded in various colours and would like to count how many cells are shaded in the various colours.
I have tried to download the Ultimate utility suggested by DominicB in the postint "Counting Colours" but I do not have access to load software onto my computer :x
Without using a macro, is this possible?
How To Tell Cell To Get The Colour Of Itself
Jan 23, 2008I am using
Range("E9").Select
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
End With
This colours the cell that colour (36) how do I say to take the colour in the cell already?
Bar Chart Colour
Oct 1, 2009I have a problem relating to a bar chart that I just can't get around. I have Excel 2003. My problem is this. I have created an attendance record sheet for members of a club. The sheet records attendances for two separate events which occur a week apart every month. The names of the members are shown vertically in one column. Multiple parallel columns then follow in which members' attendances are recorded. At the top of the sheet, at the head of each attendance column, are two headings, one on top of the other. The first of these is the date, and the second is the attendance rate shown as a percentage. I can generate a bar chart alright from these two headings. My problem is that I want some way of showing the two different events every month as two different colours, event one in red and event two in blue, so that they will stand out. So far the chart will only let me show everything in one colour.
View 9 Replies View RelatedColour Processing In VBA
Jan 17, 2007I am trying to do a conditional format for a cell and I think that it will contain some VB.
If a cell(C3) is a certain background color (gold), then I want another cell (E3) to subtract the number within the cell(C3). If the cell(C3) is not gold, then it is not to be subtracted.
How To Colour Different Bars In Bar Chart
Jan 20, 2014I have a bar chart which compares two columns of data. the data in one column is fixed to 100. the data in the other column varies. a third column states whether each entry is "A" or "M". Is there a way to include the A or M on the bar chart? Perhaps by having a set colour whether the data is A or M?
View 1 Replies View RelatedCells Need To Change Colour
Oct 23, 2008I have developed a profit loss sheet for the office I work for. What i need is to have either cells change colour or the numbers in the cell change colour depening on the value in the cell.
What I was thinking is if the number is over 15% of the sale price the cell or number should be green, if the number is under 15% it should be black, and if its below 0% it will be red.
Xl 07 Can't Change Border Colour
Jan 16, 2009I am using Excel 2007. One of my worksheets has a dark border around some cells. Instead of being blue the lines are black. I used the right click and format cells option but it does not work.
View 10 Replies View RelatedFormula (search For Colour)
Apr 22, 2009I have a large spreadsheet that is colour coded. E.g. Red means x and Blue means y etc.
Do you know if it is possible to build a formula to count how many red cells there are?
CountIf Cells Are A Certain Colour?
May 1, 2009Can I use a CountIf formula to count coloured cells that have been formatted? I tried to use a CountIf formula to count the % but because some of the warning and failing % are different that would distort my results.
View 2 Replies View RelatedConditional Formatting With Colour
Jul 17, 2009Im trying to create a stock database based on a colour traffic light system. I have 2 set columns, the first is 'recommended stock' the second is 'actual stock'
When you paste in your requirements into the 3rd column it subtracts it from the acutal stock which tells you how much your recommended stock is short by.
What ive got as well is any stock above 1+ shows up in green (this needs changing - see below), anything below 0 shows up in red. What im struggling with is i want a rule that reads the recommended stock level, then flags it up yellow when the actual stock levels drop to 10% of full stock.
how to use the conditional formatting if that is the way.