Change Color Only If Value Has Not Already Been Entered
Aug 3, 2009
I'm trying to create a spreadsheet with columns a, b, c, and d. "a" always has a value and I want columns c and d to change to a's color when they are given values. if "b" has a value when the data for c and d is entered, i want them to take b's color instead. The part I don't know how to do is that if i decide to give "b" a value, I don't want "c" or "d" to change colors if they already have values. e.g. if only a has a value when i give one to c, c will take a's color, but then if i give b a value then d, i want d to take b's color and c to retain a's color.
View 14 Replies
ADVERTISEMENT
May 15, 2013
I need to have the color of cell A2 change when I enter an asterisk in cell A1 to denote a critical dimension on an inspection form.
I used conditional formatting to change cell A1 orange when an asterisk is entered. Is there a way to tell cell A2 to look and see if there is an asterisk in A1 and if so change it's color?
View 4 Replies
View Related
Oct 25, 2012
VBA macro to change the color of a cell automatically for a specific period of time -say 5 minutes, based on the value the subject cell holds at that time. The cell value is not manually entered but comes from a sub.
There will be hundreds of such cells so that the macro must be able to be repeated for other cells utilizing their individual cell values as well.
View 9 Replies
View Related
May 4, 2007
I would like the cell to be red if the value is below 1.5. If the value is 1.5 or greater, I would like for that cell to turn green.
View 3 Replies
View Related
Aug 30, 2013
how to do basic formulas in Excel but I are hoping that there is a macro or a VBA or something that can be made which might work for what i need.
I have decided to start a small tour shop (I make the reservations for guests with a hotel in the area and take them on tours of our region) and are looking to make a booking sheet for each month. Nothing complicated just simple. see the attached .xlsx file.
I was wondering if there is a way that when the fields in column A & B are filled in if it could automatically color the corresponding dates in for the same row in the calendar area? like I have manually done on sheet "October 2013"
[URL]
View 6 Replies
View Related
Oct 22, 2009
In my Excel 2003 worksheet, I need the row color to automatically change to blue (color 5) (bgcolor = #0000FF) - when the user changes the text from VALID to INVALID in the range: B3:B65000.
For example:
Cell B5 contains the text: VALID
When the user changes the text in the field to read: INVALID - then I need the row range: A5:W5 to change to the color blue.
View 4 Replies
View Related
Feb 15, 2010
I would like to be able to change the color of a cell in V4:AB31 and have the formula in AM10:AM13 automatically calculate the new result. As it is now the user has to press Ctrl ALT f9 for the formula to recalculate.
View 7 Replies
View Related
Apr 18, 2008
I have two columns. The first one (A) contains cells that have different Fill colors. The second column (B) contains text adjacent to the colored cells. I am trying to change the color of the text in the second column (B) to the corresponding color in the adjacent cell in the first column (A). I don't think conditional formating works well in this situation. I believe the solution would be some sort of macro.
View 3 Replies
View Related
Jul 9, 2009
I have font color white in blank cells in column E and I (from row 5 to row 245) so the visitors will not see the text. If any of these cells become yellow (color code is 6), the font color will become black so visitors can see the text alot far better than white. I've tried this code myself after this post but nothing happen
View 4 Replies
View Related
Oct 17, 2006
I have various row cells in column (F) filled with the color Green. And corresponding text in Column G. How can I change the text of that particular row to white.
i.e.: if any cell in column F is Green, change the text color of that row in Column G to white?
View 5 Replies
View Related
Jun 17, 2009
an event macro to change the font colour of a cell whose value changes as a result of a calculation.
View 9 Replies
View Related
Jan 11, 2010
Not sure if I can do this with a formula or not. looking to change the value of a cell when using a column. Im looking to have the cell to change each time after there is a new value entered in the column but only when a value is entered in new cell of the column.
View 5 Replies
View Related
Jul 22, 2006
There are two worksheets: Finances and Summary. On Finances, there is data input for years, quarterly. There is a cell on Summary that depends on which year is input first, in which case the cells in the formula SUM("cell1:cell4"))/4 is currently changed manually by the user by just checking to see which year data is input first on Finances. I need a macro or a formula function where the workbook finds which year is being used on Finances first, then changes the cells in the Summary formula accordingly.
View 6 Replies
View Related
Jan 19, 2010
I need a script that changes a cell to say closed (uses a drop box) when a date is entered into the date column. I have attached a workbook with the basic options, obviously there will be a lot more columns and information in the original workbook and I will adding the code to at least 2 worksheets.
However to give a basic understanding if I have a drop box in column A with the options Active, Inactive and Closed. When I enter a date in Column B (headed Closed Date) I want Column A to change the option to Closed automatically.
View 2 Replies
View Related
Aug 30, 2007
In tab 1, I am trying get column S to change to what any time date in column F, G, H, J, L, N, Q or R get changed to-
View 9 Replies
View Related
Mar 21, 2008
I want to incoroprate into my Workbook a sheet with a list of phone numbers, that sheet can be added to and more numbers entered if necessary and will be called "DATA"
The questions is this. If one of those numbers in the "DATA" sheet is entered in any other sheet in the workbook can the cell that number has been written on (not the one on the data sheet) be made to change colour?
View 9 Replies
View Related
Jul 19, 2014
I own 3 restaurants and I use Excel to track my sales statics. I have to enter certain pieces of data on a daily basis and it can become slightly cumbersome when dealing with the sort of washed out look of Excel spreadsheets. I wanted to write a Windows application that would handle the process for me but my knowledge of programming languages is too limited and I don't really have the time to learn. What I'd like is to have a single page on my workbooks with which I can enter the data in on a field type view, and have it go to the appropriate cell on the "Raw" data sheets in the same workbook. For example:
Let's assume this is the Raw data sheet. I currently enter the data that I need here, and Excel does the rest for me. This gets hard to look at everyday when dealing with hundreds of numbers.
Net Sales
Taxes
Prior Year Sales
Percent Increase/Decrease
[Code].....
Entering the data here would automatically fill in the data on the Raw sheet, and would know which cells to put the data into based on the date, which would of course be gotten from the =Today() formula.
View 4 Replies
View Related
Jun 3, 2008
I have a drop down sub pasted to worksheet:
Private Sub ComboBox1_Change()
ComboBox1.List = Array(100, 200, 300, 400)
If Range("I11").Value < Range("N11").Value Then
If Sheets("Profile").Range("K18").Value < ComboBox1.Value Then
Range("I11").Interior.ColorIndex = 2
Else
Range("I11").Interior.ColorIndex = 3
End If
End If
End Sub
I want it to change the cell color on drop down change. How can I modify things to have the change in drop down selection?
View 9 Replies
View Related
Jun 22, 2014
I have a SS of a WW1 casualty list and one of the columns is Dates of Birth but the data has been entered in three different formats eg 21/2/1898 or 21.2.1898 or 21 Feb 1898. I have tried to Format Cells and change the date format to the slash but after highlighting a number of fields and right clicking they will not re format. Though i use Excel quite a bit i am a general user and dont understand it in depth.
article using =DATEVALUE(
am using Office 2007.
View 4 Replies
View Related
Apr 28, 2008
if a macro or private macro is necessary, I would need basic instruction how to use those as well (I mentioned private macro as I understand they automatically run whenever worksheet info is changed, which I would like in this example.)
I'm simply trying to change fonts in cells based on the inputs of other cells. Obviously, using conditional formatting doesn't allow for this.
For my example, assume the word "MrExcel" is in cells D2, F2, H2, J2, L2, N2, P2 and R2. If I type different font names (Times New Roman, Arial, Bookman, etc.) in the cells to the immediate right of each word "MrExcel," -- cells E2, G2, I2, K2, M2, O2, Q2 and S2 -- I would like the "MrExcel" word in each corresponding cell changed to the corresponding font to the right. I would like the ability to do this for up to 15 different fonts. There will be many rows to this worksheet I need to use this process for.
Is this possible? I'm in a bit of a jam and have exhausted my knowledge of formulas in that they won't work in this case ... I'm assuming I need to delve into the unknown land (to me) of macros, private macros, or VBA.
View 9 Replies
View Related
Jun 23, 2009
What I would like to do is to have the color of a tab change as the dependant upon the value of one or more cells.
View 9 Replies
View Related
Feb 21, 2014
I am using Excel 2003 at work.
New cases are entered on to the spreadsheet. The case remains open until a closure date is entered, at which point the case is closed. What I need is the following:
Cell A3 = should say "Open" if there is no value in cell Y3
Cell A3 = should say "Closed" if a date or any value is entered in cell Y3. Ideally it should only say "Closed" if a date is entered in format xx/xx/xx, but am flexible so that it says "Closed" if any data is input.
At the moment Cell A1 has a drop down list consisting of open and closed. I will remove this if it causes complication.
View 5 Replies
View Related
Nov 19, 2012
Try to find a way to automatically change the color of a row, based in changing the name in column A.
I tried conditional formatting but the name (or dates) in column A are not the same (always other and other).
I failed to adapt any VBA CODE (found in GOOGLE) because column A varies a lot.
Annex a photo and an excel example.
EXAMPLE FORUM HELP.jpg
EXAMPLE 1.xlsx
View 9 Replies
View Related
Nov 24, 2009
What formula do i use if i want the text in cell A1 to change to red if any entry is made in cell B1.
View 2 Replies
View Related
Dec 14, 2009
I am having some color problems. From A2:AB2000 I have different fill colors for cells all over the place. The only color I need is the color purple which I believe is the color “39”.
So basically all cells except the cells with the color purple change to white from A2:AB2000. I would like to add this code to the macro I have already created.
View 2 Replies
View Related
Jul 30, 2014
I have a given som (general) range where I would like a function to change the background color of every second row in a visual basic function.
One could of course just loop through it and use the mod function, but I think there has to be something quicker.
I know about conditional formatting, but it is something I need to use over and over again on Ranges that will differ in size so I would like it to be a function I can just run as part of a sub.
View 1 Replies
View Related
Feb 2, 2009
I keep recording this macro, but the problem I run into is that the active sheet is always the specific name of the sheet. I need a general name so that the macro will work on any given sheet. On the sheet I am viewing, I simply want to change the tab color to black using a macro.
View 2 Replies
View Related
Feb 10, 2012
Using Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) I can execute code when values in the cell change, but it can't check if the foreground or background color changes. What event can detect this? If no event can, is there any way at all?
Found this, I will look into this loop: Capturing cell color change in VBA
View 5 Replies
View Related
Nov 22, 2012
I'm trying to put together a script which changes the color of the row in columns A:AE if any cell in the Range B7:B400 has the value of 'No'. If it has the value of 'Yes' I would like it to Exit Sub.
I've put together the code below to try an create this function, but I'm running into a few problems.
Code:
If Intersect(Target, Range("B7:B400")) Is Nothing Then Exit Sub
If Selection.Cells.Count > 1 Then Exit Sub
If Target "No" Then[code]....
When the value of any cell in Range B7:B400 is 'Yes' the row changes to grey, if I enter 'No' it removes all cell shading from the row, and I'm not very clear on what changes I need to make.
View 2 Replies
View Related
Jan 3, 2007
I am in need of a way to change the color of text in a cell to red if that cell contains a dollar sign ($) and if it dosen't contain a dollar sign ($) for the text to be black. I want this to happen automatically without having to run a macro, is this possible?
View 9 Replies
View Related