Creating Static Cell Colors

Jun 17, 2009

How do I make the colors of certain cells on my spreadsheet static and unchangeable by cell data that may be copied and pasted from other cells of different color? Is this possible?

View 6 Replies


ADVERTISEMENT

Creating A Dropdown List With Pass/Fail With Colors

Oct 16, 2007

I am going to use excel for test cases. I can creat a drop down list with the selections "pass", "fail", "not run". That isn't a problem using the data validation toolbar. However I would like to basically color the cell (test case) with a certain color based on the drop down selection.

for instance:

Pass = Green
Fail = Red
Not run = Orange.

View 9 Replies View Related

Excel Pallet Lost Colors (hovering Displays Colors But Visual Clues Are Not Shown)

Jul 7, 2013

My pallet lost color-coding - if I hover over each little scare it displays the names for the colors and if I click on them they color the cells with the right colors, but the palette itself lost the visual display of colors except for 8 colors: black, blue, red, magenta, yellow, cyan, and white.

I use color-coding of cells a lot and I find it difficult to work without visual clues. At least the hover-support allows me to get the work done, but with difficulty.

View 12 Replies View Related

Auto Populate Cell With Static Date As Another Cell Is Populated

Jan 25, 2008

I have used the following =IF(ISBLANK(Q6),"",(NOW())) & =IF(ISBLANK(Q6),"",(Today())),
but when the excel file is closed and opened the date changes to now or today. How can I make the date stay and not change?

View 4 Replies View Related

Save As With Static Name Along With Cell C1 Value

Mar 13, 2012

I have developed an excel template that is used at our fire department for dispatching purposes. The template is loaded and then info is placed into the template. It is a read only file so I am looking to have it save the file name as "Incident Report ()" replacing the bracket will be the value of cell C1. Example would be "Incident Report 234". I would also like it to save in the same file location every time.

View 6 Replies View Related

Reference Cell X Rows/Columns From Static Cell

Feb 15, 2008

I have a worksheet where everything in column A links to a different workbook. Does anyone know if there is a formula that can then look at the cell reference in column A and take the value from a set row in that same column? For example:

The cell in column A2 is set to cell Q1 in a different workbook. I need a formula in cell C2 that will then bring in the value of cell Q64 in that same workbook. Therefore always bringing in the value of row 64 for whichever column the cell in column A is et to.

View 5 Replies View Related

Workaround For Public Variable Bug: Creates Different Cell Colors Based Upon The Cell Contents

Oct 15, 2008

I am in the process of reformatting an excel workbook to act as a review tool for different factors in a process. Part of my redesign includes the use of coding that creates different cell colors based upon the cell contents. The new workbooks will be used to handle existing data for this year. I have developed a process macro to open an existing workbook and copy and transfer the original data worksheet into the newly formatted workbook. The data gets transferred to the new worksheet and the resulting workbook is renamed and saved, Heres'' the rub... the newly saved workbook is missing all of the coding for the worksheets... apparently this is a MS bug.

Has anyone figured a workaround for this. One thought I had is to open both( new and old )workbooks and rather than move/copy , i would transfer the data using cell references.

View 5 Replies View Related

Add Static Date & Time To Cell

Nov 8, 2006

I am not sure whether this can happen, I want to capture time taken for different activities, without manually entering the details.I tried the formula "=Now()", but what happens is that at the end of the day the times are all the same because the live time is changing. Is there a way where the live time is captured and freezed, so that at the end of the day i have a time log sheet.

View 9 Replies View Related

Changing Cell Colors

Apr 3, 2012

Trying to format cells b9 through b 24 and cells c9 through c24 to change from white to a light grey color by clicking the mouse button once. so one click white, another click grey. The color grey I need is white, background 1, darker 25% in the autofill field in excel. I have search other forums they all lead to changing the code, I did this already. just copy pasted a code I found but all cells were selected to change a bright green.

View 3 Replies View Related

Change Colors In A Cell?

Jun 27, 2012

I am making some grids which will have a series of numbers in the individual cells. But I can't figure out how to change the colors of the digits. If I change one digit to Red; all the numbers in that cell change to Red. Whereas I would like to have them as Red,Green,Black,Blue,etc.

View 3 Replies View Related

VBA To Change Cell Colors?

Jun 25, 2013

I'm trying to update a workbook with a new look and want to change the cell color based upon what the cell color currently is.

I'm having problems with the code that I created. I just can't seem to get the syntax correct for the code.

For the code below, my Range of A5:D5 is just a test range where each cell should change colors. When completed, my range will be much greater.

Code:
Sub ChangeColors()
Dim Cell As Range
For Each Cell In Range("A5:D5")

[Code]....

View 4 Replies View Related

Cell Colors Not Formatting

May 23, 2009

I have read the instructions for conditional formatting and I don't think that is what I need. I have 10 diff year 2005,06,07 etc. I want each cell with with a diff year to turn a diff color. Like I want 2005 to be red and 2008 to be blue.

View 9 Replies View Related

Changing Cell Colors With Vba

Mar 17, 2007

I'm trying to have change if the date on it is passed "now()". I am already using the 3 conditional formatting fields and need this one and another one. Here are 2 problems I seem to be having.

First - the code below only works if I change the date on the cell. I want code to either work with Worksheet Active or any other way so the user does not have to redo the date’s everyday.
Second - a record might have conditional formatting already. Is it possible for the target cell in this code can show this color while the rest of the row shows the color of the conditional formatting?

Private Sub Worksheet_Change(ByVal Target As Range)
Dim icolor As Integer
If Not Intersect(Target, Range("G1:G2000")) Is Nothing Then
Select Case Target
Case Is <= Now()
icolor = 39

End Select

Target.Interior.ColorIndex = icolor
End If

End Sub

View 7 Replies View Related

Using Static Cell While Dragging Formula Across Rows?

Aug 21, 2013

Let's say I have a value in B2, and a formula in C2. If I drag the formula from C2 all the way down to C20 (spreading it 18 times), the formula wants the value in B2, B3, B4, etc.. down to B20. How do I drag a formula, but have it always reference B2?

View 1 Replies View Related

Hyperlink To Static URL And Then Include Cell Reference

Mar 25, 2014

I need to create a Hyperlink to a static URL but then add a cell reference

The static url is known - [URL]

A column in my spreadsheet contains the data needed to add to the end of the static URL - so it would look like [URL]

I tried this

=HPYERLINK("www.helloworld.com)+B2,Link - but it is not working :-(

View 1 Replies View Related

Static Date & Time Corresponding To Cell Change

Aug 15, 2008

REQUEST 1

What I need is lets say I have 3 columns Name, Date & Time

Name field has a drop down menu having a list of names

Now what I need is - lets say from the dropdown menu someone selects a name - THEN at the same instance the Time & Date fields gets populated with the Date & Time of that update.

and that Date & Time shouldn’t change if someone selects the same or different name in the row below

Kindly assist in lay man terms as I am a novice to Excel


REQUEST 2

In this format what I need is like above , the start date & start time should update real time ONLY when a name is selected

and when the End date is selected the End time , Date Elapsed & Time Elapsed should Populate automatically.

However there should be NO effect if data is entered or changed in the Request Id or Issue Cells - basically the triggers should only be Name field & End date Field

Can you attach an example sheet as well please

Have enclosed an sample attachment

View 9 Replies View Related

Static Time Stamp For Active Cell

Oct 5, 2006

I need VBA code for a time stamp. I just need code that will allow me to have a time stamp inserted in the current cell.

View 2 Replies View Related

Static Date Stamp Certains Cell Changes

Feb 14, 2008

I belive i have a simple date stamp problem, but i do not know the correct VBA to edit the code posted below. I would like to have a datestamp placed in an adjacent cell based upon a particular value. For instance, If Cancel is entered into cell a2, then b2 would gave the date stamp. or if Started was entered into a2, then c2 would have the date stamp.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
With Target(1, 2)
.Value = Date
.EntireColumn.AutoFit
End With
End If
End Sub

View 3 Replies View Related

Changing Colors In Specific Cell When Conditions Met In Another Cell

Apr 22, 2014

I need to change the color of a specific cell when conditions are met in a different cell and it seems like it may be beyond the scope of simply applying conditional formatting. What vba code would look like in proper syntax to make the following statement true. IF cell value Q4 is >=cell value S4 AND cell value R4 is <100 Then cell Q4 turns red and IF cell value Q4 is >= cell value S4 AND cell value R4 =100 then cell Q4 turns green. it may also be useful to know that the "cell values" in this example will be dates and not straight values. this may be possible to do using conditional formatting, but i cannot find a formula that works.

View 2 Replies View Related

Move Value From Calculated Cell As Static Value To Another Cell?

Jul 22, 2014

I have a filtered row that calculates values based on user input. I would like to take the calculated value of a cell in that row and place it as a static value in a different cell.

For example, the filtered row is row 85. The user inputs 5.5%. Cell AK85 calculates the value to be $100,000. Cell AK3 references the original row, which is 3. I would like to take the $100,000 value and place it in cell AK3 but as a static value and not based on a formula.

View 1 Replies View Related

Cell Fill (Background) Colors

Mar 6, 2009

when I copy a worksheet from one workbook to another, the colors on the sheet in the destination workbook, become dull/faded. They actually change from the original colors to some off colors. I copy by selecting the source sheet, hold down ctrl key, then drag from one workbook to another). Also, is there a way to get the sheet back to the original colors.

View 2 Replies View Related

Change Colors Depending On Value In Cell AI1

May 22, 2014

I have a few buttons on my page that I would like to change colors depending on the value in cell AI1. Right now this is the code I have:

[Code] .......

What I would like is to add formatting for "rounded rectangle 4" as well. if the cell = 1, number 4 changes color, if the cell = 2 both change color, and if the cell =3 then only 5 changes color.

View 2 Replies View Related

Matching Cell To Change Colors?

Apr 16, 2009

If cell A1 is the same thing at cell B15 then I would like cell A1 to turn RED. Is there a way to do this?

View 5 Replies View Related

Change Tab Colors Based On Cell Value

Dec 9, 2011

I need to change the colors of each tab based on the cell value in G132.

1>Green
1

View 3 Replies View Related

Macro To Detect Cell Colors

Sep 8, 2009

We have a workbook with over 20 worksheets, each sheet with one or more tables in it. Several people use the workbook and we have decided that when someone changes a cell, they should mark the changed cell by filling it with blue using Format Cell. We have then nominated one person at end of each week who will check all the changes made during the week and either approve or reject them. So her task is to find all the blue cells, check them and then take the shading off.

What I would like to do is to create a macro to help her. I would like the macro to automatically identify all the blue cells in the workbook and give her a list of these cells. I wonder if someone could give me direction on a couple of things:

1) The command in the macro that would return whether a cell is shaded blue

2) The way in which I could cycle through all the content of each worksheet. I'm thinking worse case I would have to write instructions to go to each sheet, and then do an outer loop to go through each row, and an inner loop for each column (and the number of active cells varies by worksheet) -

View 9 Replies View Related

Print Data Without Any Cell Colors

Oct 17, 2006

Within the Workbook events there is a "Before_Print", however I also need something like "After_Print" which does not exist (as far as I can tell).

I have several rows of data which alternate colors. When I print it I want to take out the fill (so as to save ink) - which I can do in the "Before_Print" event. [No problem.] However, once it is done printing I need to restore the alternating colors, but I cannot think of any event or trigger which would enable this.

I have thought through several things and the closest thing I can think of is setting up a timer. But there is of course no way to now how long to set it for. [Before/After Save also has the same "issue".]

View 9 Replies View Related

Automatically Remove Cell Colors

Oct 30, 2006

i am using a set of VB codes that was kindly provided by "dr". Please refer to the link below.

Highlight-Select Start Date To End Date

However, I am facing problems on how to delete or unfill the cells that are "coloured and filled with booking reference name" (i.e. being booked by the user).

In another words, currently, once a booking is made, the blank slots would be coloured to red and would reflect the customer name in those slots (with the use of dr's VB codes).

Comes the next day, if that booking needs to be cancelled, would the user be able to "delete" that booking that was made (i.e. uncolour that slot plus remove the customer name) without having to automatically go unfill the cells and delete the text in the cells?

View 5 Replies View Related

Synchronize Cell Colors Between 2 Tables

Jan 17, 2008

I am trying to write a macro that can copy the shading from another cell for me automatically. I would like to look for certain text strings within a serial number, and when found, copy that cell's shading in another cell.

I am using INDEX, MATCH to copy the corresponding value needed, but that doesn't give me the shading...

View 6 Replies View Related

Make Static Date Appear When Cell Has Text Entered?

Jan 19, 2014

Any way where is a list of cells (b3:b113) has text entered, or specific text entered, it will enter a static cell in the corresponding "d" column.

I know of CTRL + ; but i don't really know how to get it to work as a macro, can't find a forumla that enters the static date, and i don't want to make a macro to copy + paste special the date when it happens.

So all i should have to do is entered text in column b, then it will add a time stamp, when that text was entered, it doesn't have to update.

Like all i need is this, but instead of the "now()" function, it will have another function that doesn't automatically update?

=IF(ISBLANK(E5)=FALSE,NOW(),"")

View 2 Replies View Related

Copy And Paste A Range Based On A Cell Value That Is Not Static?

Aug 8, 2014

Task:A user has to copy and paste a range of cells, if any row in column B has "PM" as a value.

I have several macros/VBS scripts that copy and paste from one workbook to another, how do I create a macro that says whatever row "PM" is in copy range F:BC on that row

My issues is the fact the PM can be in any row in column B in different sheets. Example.xlsx

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved