Follow On From Cell Colours As Criteria
Feb 19, 2007does anyone know of a way to amend this to add the cell to a range say "All_blue" to then copy and paste special values.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) ...
ADVERTISEMENT
Top 3 With Dark Colours - Remaining 2 With Light Colours In Conditional Formatting?
May 6, 2014 I'm sure this will be an easy query.
These are marks scored by 5 people in 10 exams
Name of the student
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS[code]....
Range
A1 to K6
In each row top 5 MARKS should be filled with BLUE,VIOLET,YELLOW,RED AND PINK
If its not possible. Top 3 with dark colour, remaining 2 with light colour using conditional formatting
Metallic Background Colours / Other Colours
Oct 29, 2007The idea came about after wanting to show a 'gold' 'silver' and 'bronze' background colour, but having to plump for yellow, grey and orange looked a little crap :f
If not, can a workaround be created by using code and a picture or 2?
Follow A Hyperlink In A Cell
Apr 10, 2007how would I, with a macro, follow a hyperlink in a cell.
cell c3 holds the hyperlink, how would i get the macro to follow it
VBA To Follow Formula To Referenced Range And Edit Source Cell
Feb 23, 2014I have tried numerous versions of macros I found. Most get the same error of; Range object error or script error.
Here is the formula: VLOOKUP(C$13,VESSELS_DATA,ROW(30:30)-12)
What I would like to do:
1) double click to on the cell with the formula
2) goto the worksheet "DATA_TABLES" that contains the Named Range "VESSELS_DATA"
3) go down the rows until the c13 is matched
4) offset column the same as in the above formula "Row(30:30)-12"
Follow Cell Address Stored In A Cell
Mar 22, 2012I have three columns:
Column A: Old Value
Column B: New Value
Column C: Cell address of the old value, which is on a different worksheet. For example: Sheet1!$A$1
What I'm trying to accomplish with a macro/VBA is:
Copy the new value from cell B2
Paste the value into the cell address listed in cell C2
Repeat for row 3 and so on, going down 100 rows in total.
Should I make the addresses in column C hyperlinks and follow the hyperlinks somehow?
Manipulation Cell Colours
Jun 22, 2009Is it possible to create a formula that looks at a cell (say A20) and if TRUE changes the colour of A22 to green if false to red?
View 9 Replies View RelatedUse Cell Colours In Graph
Feb 21, 2007Attached is a table detailing top 20 Incidents and Requests. Requests are highlighted in Yellow and Incidents are in Green. Associated with this table is a graph. What I like to do is if the bar on the graph represents a Request I want the colour to be yellow and if the bar represents an Incident I want it to be green. At the moment I can only choice one colour or a different colour for each bar.
View 4 Replies View RelatedHow To Follow A Cell From A Linked Cell
Mar 7, 2014I have two sheets.
On sheet one (named Master) I have:
Apples
Cantaloupes
Bananas
On sheet two (named Customer) I have the following formulas
='Master'!A1
='Master'!A2
='Master'!A3
Now, if I install a filter in the Master sheet, and sort alphabetically the link formulas on sheet two remain the same, and because of that, in sheet two they would be in alphabetical order as well. BUT what if I wanted the links on sheet two to follow the actual cell in the master sheet, so that even after a sort, the links on sheet 2 would show the same values, so the formulas on sheet two would end up looking like this (DESPITE being sorted on the master sheet)
='Master'!A1
='Master'!A3
='Master'!A2
Basically I would want the linked cells on sheet 2 to represent a static value no matter where it was moved to on the static sheet.
A Cell Colour Based On 5 Other Cell Colours That Have Been Conditionally Formatted
Jun 30, 2009Using 2007, I need to conditionally format a cell colour based on 5 other cell colours that have been conditionally formatted. The 5 other cells will be coloured either red or greem. What I want to do is have an overall status cell that would be show green if all of the other 5 cells were green, amber if 4 of the other cells were green and one was red and red if 3 or more cells are red.
View 4 Replies View RelatedKeep Cell Colours Regardless Of Sort Function
Jan 8, 2010I have a vertical list where every other cell is coloured grey. The values contained in the list are regularly sorted into alphabetical order with new values being added and other being removed.
Is there a way to keep the cells alternate grey & white after I have sorted them? Currently, when I sort, if a cell is coloured grey and is moved down one cell the colour is moved and not just the values.
Counting Numbers And Colours Within Cell?
Jan 31, 2013I wish to count the "number" of numbers in a cell i.e.
Cell A1 has the following data: 12 25 25
This should return 3
Simillarly 4546546545646456 1 2
Should also return 3
I will have data such as the above in a row so i need the count to be able to count a range as opposed to the single cell example above.
Furthermore I need a separate count to count the number or red numbers in a cell. Same parameters as above.
Change Cell Colours When Inputed In Another
May 29, 2009was looking if you could change a row of cells background colour if certain word is inputted elsewhere. in b2:f2 is data- was looking if, could these cells background colour change when yes is entered in G2? does not matter which is used, VBA or con formatting just cant work it out.
View 9 Replies View RelatedSelecting Cell Range Of Colours
Oct 21, 2009Is it possible to select only cells of a certain colour, then change these cells to a different colour? example
I want to make the dark grey columns a light green and the red columns a lets say yellow and the text black. Is this possible??
Changing Cell Colours Depending On Cell Content
Nov 19, 2008What I need to do is have a cell that will be say yellow until there is information put into this cell. The information could be in the format of text or numbers. The information would not always be the same so it would need to be yellow when there is no information in the cell and another colour or white when there is information in the cell.
View 6 Replies View RelatedDistinct Colours In A Cell And Conditional Formatting
Feb 8, 2010This question about conditional formatting appears to be easy. Lets say I have a column like the following, like I posted somewhere else: (not very relevant for this)
BGW
3UG
WWU
1BR
UUBRG
WUBRG
7UUGGRRR
How do I have all characters in this column be coloured accordingly to:
W = WHITE
U = BLUE
B = BLACK
R = RED
G = GREEN
So that 7UUGGRRR would automatically switch to:
7UUGGRRR
What I already tried:
- I applied conditional formatting to the column (actually, the cells interval, [C2..C8]) creating the rule: 'format only cells that contain -> specific text' -> then I added "U" as the text and told it to colour blue. As I predicted, this didn't work; the entire cell containing a single "U" will get blue, which is unwanted.
Cell Colours For Negative And Positive Values
Jan 24, 2014I've got 12 months worth of business accounts which have been downloaded onto a single spreadsheet.
These show negative and positive values. As I only want to work on the negative figs at the moment, how do I highlight the colour of the positive value cells or font to prevent any mistakes ?
Copy Cell Interior Colours Between Workbooks
Jan 26, 2008i am pretty good with VBA after reading a lot of information on the internet but i have a problem i cannot solve:
I have two workbooks with the same sheet names and I am trying to transfer the interior colour of cells from one workbook to the other...
this is the code i came up so far but it doesn't work
With Application.Workbooks(WB1).Worksheets
For Each ws In Application.Workbooks(WB2).Worksheets
On Error Resume Next
For Each cl In ws.UsedRange
WB1.ws.cl.Interior.ColorIndex = WB2.ws.cl.Interior.ColorIndex
Next cl
Next ws
End With
Change Cell Colours Based On Date Range In Two Other Cells
Sep 12, 2012I'm creating a project calendar in Excel and for each task I have a Start Date (A) and End Date (B) in adjacent cells. To the right are corresponding date cells like a timeline set up with 52 cells representing weeks of the year. I.e Week 1 (C) starts at 02 Jul 12, Week 2 (D) starts at 09 jul 12 etc. up to 24 Jun 14 (BF).
Start Date
End date
02-Jul-12
09-Jul-12
[Code]......
When a start date and end date are entered in the respective columns, I need to have the color start on the cell for that range in the timeline and that color should carry out to the end date cell in the timeline. A bit like a Gantt chart but not to that detail.
VBA To Not Follow Hyperlinks
Oct 17, 2013Is there anyway in VBA, that if a hyperlink is clicked on in the spreadsheet that it won't follow the link?
I need it to be a link in every other respect because I will be parsing the Text to Display, and utilizing the links address. I just would like to not have the link be clickable on the spreadsheet.
Follow Hyperlink, Then Do Something Else
Nov 13, 2009I have hyperlinks set up in a spreadsheet. I want something to happen once I click the hyperlink, like go to another cell, color the cell, put a value in it. Whatever. I just can't figure out how to do anything like that. Is there VBA that could determine if the active cell hyperlink has been clicked? Like by checking the text color maybe or something like that? Let's say for simplicity sake, I just want to put a 1 in the cell next to the cell with the hyperlink I just clicked.
View 9 Replies View RelatedPictures Don't Follow Their Rows?
Jun 13, 2014I would like to sort the rows but the pictures don't all follow their rows.
The pictures are just images I Inserted into the first cells.
Follow Hyperlink With Macro
Oct 23, 2007I want to use a macro (assigned to a button) to open a file named in a hyperlink.
When I record the macro it results in the file being opened, but when I run the resulting macro it only selects the cell, it doesn't follow the hyperlink.
If Statement In Macro: Macro To Change A Range Of Cells Colours Based On A Single Cell?
Mar 16, 20071st - Need a macro to change a range of cells colours based on a single cell having a value greater than 0.001. ie. cells A1 - G1 need to change to grey based on cell F1 having a value greater than 0.001 entered in it?
2nd - Also a macro for deleting the text contents of cell C1 based on cell F1 having a value greater than 0.001. Therefor if cell F1 has a number greater than 0.001 it changes the colour of celss A1 - G1 and also deletes the text in cell C1?
Follow Up To Using COUNT, But Now With Interupted Cells
Jan 12, 2009A1/A2 is Monday, A3/A4 is Tuesday, A5/A6 is Wednesday, A7/A8 is Thursday, A9/A10 is Friday, A11/A12 is Saturday, A13/A14 is Sunday. A15/A16 os Totals. Each of the two cells are merged to hold the heading.
B1 is Plan, B2 is Actual, B3 is Plan, B4 is Actual, B5 is Plan, B6 is actual and so on.
Here is the problem:
The formula suggested was =SUM(A2:G2)/COUNT(A2:G2) which was fine when I only had the one column for "Plan", but now I have added a second column for "Actual" next to each "Plan" but I still need a formula that will add every second cell and average it out allowing for the odd time that one of the cells could contain text indicating a holiday and therefor be one less day with data and require to be divided by 6 instead of 7 for example to get the average.
Drag Fill To Follow Pattern And Skip Row
Mar 9, 2014Attached is a sample worksheet. I have data in column A that I want to drag fill in column C. In column C, once the first 2 results in column A are entered, I would like a blank cell and so on.
testdv.xlsx
Creating Patterns For Auto Fill To Follow?
Aug 20, 2014I'm trying to create an auto fill pattern to match B4-M4 then repeat with B5-M5 and continue to 350.
So for example, I'd like to manually enter "B4,C4,D4,E4,F4,G4,H4,I4,J4,K4,L4,M4,B5,C5,D5,E5,F5,G5,H5,I5,J5,K5,L5,M5" into column A and drag the auto fill box down until I've repeated the pattern to match all the way to M350.
Is this possible? I tried just entering the pattern as I've posted and dragging the auto fill down, but it doesn't fill the numbers properly and ends up with a strange pattern.
Making Spacebar Follow A Keystroke Pattern????? Add-in???
Dec 7, 2006I am using a bar code gun to enter numbers. There are two bar codes on each item that I am scanning requiring two columns for each item. Right now I squeeze the trigger and the number pops up into the currently active cell. Then I use the arrow key to move over one cell and squeeze the trigger for the next number. Then Down arrow following with a left arrow to move the highlighted cell down one line back to the first column. Kind of inefficient because although repetitive there is room for errors on my part.
Is there a way to make it that every time I press the space bar or some other key that excel highlights a cell following my desired pattern? At least for the time that I am using the bar code gun? Making it so pressing the space bar would advance the selected cell over, then down and left, then over, then down and left, alternating with each press following that pattern ad infinitum. I have to scan hundreds of these babies.
Would this be difficult? I’m not the programming type. Any help would be greatly appreciated. At least I no longer have to manually type each number in. That was a real bummer.
Display Cursor Follow Order Of Filling Out In Userform?
May 24, 2012How to display the cursor follow the order of filling out in userform?
View 9 Replies View RelatedVBA Macro To Follow Hyperlinks & Save Files To Another Location
Jan 16, 2010I am attempting to write an Excel macro that will be stored in a file called MacroFile. The purpose of the macro is to
1. Follow a hyperlink to an Excel file saved in a SharePoint type enviroment
2. Save the file to my laptop directory My Documents.
Below is the code I have written. The code is following the hyperlink and saving a file but is the focus file is incorrect.
Here is what happens:
1. Open up MacroFile and run macro
2. Hyperlinked file LinkedFile_1.xls is opened
3. File NewFile_1 is saved but contains the info from MacroFile
4. Hyperlinked file LinkedFile_2.xls is opened
5. File NewFile_2 is saved but contains the info from LinkedFile_1
6. Hyperlinked file LinkedFile_3.xls is opened
7. File NewFile_3 is saved but contains the info from LinkedFile_2
The files created are named correctly but have the wrong data in them. I need to know how to control which file is considered ActiveWorkbook.
Sub LinkAndCopy()
Application. ScreenUpdating = False
Application.DisplayAlerts = False
'**** Copy LinkedFile_1..................