COLOR Items, Text & Cell(s), Unresponsive
I should much appreciate your help on this strange new problem which is twofold:
1. Clicking either color item (for text or for cell) brings no change in designated cell(s)
2. When colors appear on Print Preview they do not on the Printout.
It occurs on Dell Vista Ultimate SP2. Am on IE8; Ctrl Panel list also shows !E7.
It does not occur on HP XP SP3 desktop although no discernable differences in spreadsheet.
On laptop I am unable to use either COLOR icons -- for text or for cells. No trouble heretofore which makes it so frustrating.
Ordinarily, following usual usage, all is well. For unknown reasons, now neither has any effect.
Explored for cause/cure without finding anything more than instructions already well known.
Did see note saying High Contrast might make colors ineffective, so searched out that.
Found how to turn on/off, and easily turned off High Contrast. Made no difference.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Color Cell Fonts Based On Text Color Of TextBox Controls On UserForm
I have got a userform with lots of controls, One of the action's on a large group of the controls is the same but except for one number here is an example If TextBox107.ForeColor = 255 Then ActiveCell. Offset(0, 53).Font.ColorIndex = 3 If TextBox108.ForeColor = 255 Then ActiveCell.Offset(0, 54).Font.ColorIndex = 3 If TextBox109.ForeColor = 255 Then ActiveCell.Offset(0, 55).Font.ColorIndex = 3 This makes a cell that correlates to the textbox red if the text in the textbox is red. Now, I loads of these textboxes that all need to run the same code with just the Offset value one digit higher than the last and I was hoping I could create a loop to avoid a huge block of code but I can't work out how to make a constant that will +1 with each loop. Also, can I assume that a loop will start with the control with the lowest number i.e. Textbox1 and then work its way through the rest of them in order?
View Replies!
View Related
Change Text Color Based On Cell Color
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 Replies!
View Related
Text Color Change - Cell By Cell Basis - When Budget Is Reached
I'm a business/application consultant for ERP software, and generally pretty solid when it comes to excel. However, I've come across a question for a personal sheet that I can't seem to solve. In my personal budget worksheet, I'd like to set a budget on a cell-by-cell basis. When the budget is hit, I'd like the text color (or cell color) to change. I.E. Cell D14 has a budget of $200. When I enter $200 in the cell, the text turns from black to red. I've searched through google with no luck. I have mildly searched this forum, but haven't found my direct answer - I have come pretty close though, in other languages
View Replies!
View Related
Automatic Text Based On Cell Color
I would like to have a cell automatically change text based on a conditional formatting formula. When the cell color is red, or the formula is true, then display the word "Expired". Can a formula be devised using results from conditional formatting? This is being used for expired CPR 2-year certifications. When the certification expires, the cell currently turns red (based on a cell formula) and I would also like the word "Expired" to replace the date. My condition formula is: =TODAY()>A2 + 730
View Replies!
View Related
Color Format A Portion Of Text Within A Cell
I have a column of data that contain miscellaneous comments in each of the cells in column 'A'. This is a sample of the text in one of those cells: The quick brown fox jumps over the lazy dog. Is there a way to programmaticly search each cell in col 'A' to look for any occurrence of the string 'fox jumps over' and highlite in RED only that string occurrence? So in the end the above cell would now be: The quick brown fox jumps over the lazy dog.
View Replies!
View Related
Changing Cell Text Color When Out Of List Scope
I have a worksheet with 3 particular columns (L,M,N) that have drop down menus. The menu is populated with items that are referenced on a different workbook (different file). Because there are multiple worksheets accessing the referenced list, this is a master. When I change the master, the lists update, but the cell text does not. Example: If I chose apple from the list, but later in the master I decide I want apple to be banana, while the drop dowm box will now have banana instead of apple, my cell still says apple. I don't necessarily want apple to change to banana, but I want a visual cue that this is incorrect. I wanted the cell text to change to red if it is not equal to any of the list items on the master file. I want this to be passive, i.e., I want it to change automatically, so I don't have to press a button or some other activation.
View Replies!
View Related
Extract Text In Single Cell Based On Font Color
I have a cell that has a formula in it like PREM + PRDCMP + ACQ + DLR in a spreadsheet that looks like this: PREM PRDCMP ACQ DLR VIP COMM TOTAL 2 1 3 4 6 5 PREM + PRDCMP + ACQ + DLR 2 1 3 4 10 where PREM + PRDCMP + ACQ are colored red and + DLR is colored blue. This formula is entered in that particular cell as a text string. I have a formula in the PREM column that says if the word PREM is located in the formula to the left (and it is), then put the value that is located right under the PREM column (2) in the blank cell next to the formula. So, in the above example, I have an IF statement that sees that PREM is in the formula to the left and so underneath the PREM column, next to the formula, it would place the number 2. Now, I need Excel to detect if any word in the formula text string is colored blue and if it is, to put a zero in that column. So, in the formula above, if + DLR is the only text that is blue, I want to have Excel add 2 + 1 + 3 only. I want to have Excel take any string out that might be colored blue, such as + DLR and return the value of zero for it. The purpose of the different colors in the formula is to distinguish which information is relevant and which information should be ignored. So, I'd like Excel to read the above formula and say put the PREM amount in the cell under PREM, put the PRDCMP amount in the cell underneath PRDCMP, put the ACQ amount in a cell under ACQ and put zero in the DLR column since it is colored blue. If any of them (PREM, PRDCMP, ACQ, DLR, VIP or COMM) are colored blue, I want Excel to put a zero in that column.
View Replies!
View Related
Setting Color Of Range Based On Adjacent Cell Color
This is probably elementary, but I'm struggling and would appreciate any help as I have very little excel VBA experience to draw from. I have assembled code which changes the cell color based on a value change in Column A. Column A will contain many different groups of repeating values. This code works well and and I have been able to figure out how to limit the number of colors to only 2. The end result is each set of similar values in column A is visually grouped by one of two alternating colors. The number rows in the data set is variable as the data set is extracted from SAP. The number of columns is fixed. What I want to do now is set the cell color in columns B through F the same color that was assigned to the row in column A. So if cell A3 is set to colorindex = 6, then I want to set the range of cells B3 to E3 to the same color. Here is the code I am using to set the color of the cells in Column A:
View Replies!
View Related
Change Font Color Based On Adjacent Cell Color
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 Replies!
View Related
Counting Unique Items(values Or Text)
I want to count unique items in a list with an array formula, like the items is in 3 columns A,B,C are from row 2 to 101. Now i use an array to filter out some rows in the columns of B,C & then count unique items in Column A. so, column A has "30 diffrent names repeated from A2 to A101" column B has numbers 0 to 100 column c has value either 0 or 1 now i use an formula TO filter out rows in column B & c formula =count(IF((B2:B101>0)*(C2:C101<>1),1))) using ctrl+shift+enter now what should i suffix or prefix to this formula to count unique values in column A.
View Replies!
View Related
Change Font Color If Cell Color Become Yellow (6)
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 Replies!
View Related
Color Cells Based On Color Of Preceeding Cell
I am looking for a very simple script that will achieve the following: On the clicking of a button, Select and shade in a cell yellow, delete the yellow shading of the previous cell. The shading & selection should move up a column of cells, 1 at a time, in the following order: From B10 to B9, then B9 to B8, B8 to B7 etc until the selection and shading is at B2. Once it is at B2 subsequent clicks will simply keep it at B2 (the top). Thus after 8 clicks the shading & selection should travel from B10 to B2, with only 1 cell being shaded yellow and selected at any one time.
View Replies!
View Related
Color Chart Data Points By Cell Color
if it actually possible to colour data points depending on the colour of the cell of the data it refers to? if not is it possible to colour it any other way i have uneven amounts of data for weach month but still want the months to be displayed, this is the best way i can think of of doing this
View Replies!
View Related
Count Multiple Text Items Inside A Given Date Range
I have data in 2 columns. COLUMN A COLUMN B 2008-01-01 00:00:00 CRIMINAL EVENT 2008-01-04 00:34:48 OTHER 2008-02-04 00:23:59 SUSPICIOUS INCIDENT 2008-01-31 23:59:59 ENEMY ACTION 2008-01-08 00:45:43 FRIENDLY ACTION 2008-01-09-00:45:33 RAID I need a formula or macro that will count all the times "Criminal Event", "Other", "Suspicious Incident", and "Enemy Action" occured in January. Also if possible I need to not specify column ranges, such as A2:A7, but instead it needs to find the last cell containing data in Columns A and B, and use that as the end point. For example it would search A2:Last Cell Containing Data
View Replies!
View Related
Searching A Column For Specific Text To Return A Number Of Items Found
on one sheet we have a summary of the main list, which includes totals of money recieved, totals of all the different sources (ie, where they heard about us from), the totals of the frequencies they pay (ie, how many donate monthly, quarterly...) ... etc. on the next sheet we have the "main" list of donors, their IDs, amounts, frequency, source ... the totals on the first sheet are updated manually, but i want to change that as there are a great number of errors.
View Replies!
View Related
IF Contains Text Then Color
I have a spreadsheet with a few thousand rows. How can I background color all rows RED that 'contain' the text "Ping" in column F, and also background color all rows GREEN that 'contain' the text "CPU" in column F, and so on....with more textual items that exist in cells in column F?
View Replies!
View Related
Color The Cells Which Contains The Text
Tried to record a macro which needs to color the cells which contains the following text, "Next mail needs to be sent", the problem which i am facing is; its currently coloring the cell which was recorded in the macro, which is G46, but i want all the cells which contains the above text to be colored. Sub color() Selection.AutoFilter Range("A1").Select Selection.End(xlToRight).Select Selection.AutoFilter Field:=7, Criteria1:="=*Next mail needs to be sent*", _ Operator:=xlAnd ActiveWindow.SmallScroll Down:=-3 Range("G46").Select Selection.Interior.ColorIndex = 50 End Sub
View Replies!
View Related
Text Color Code
Is it possible to have a code that says if I have a range of cells....say a1:d1 with d1 having a date in it....have that code say that if that date in d1 is greater than 30 days from today, make that whole range of cells (a1:d1) change color like to red.
View Replies!
View Related
To Change Text Color
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 Replies!
View Related
Sum 1 Or More Items In A Cell
I have a monthly calendar on each sheet for employees, attached is a copy of one of the sheets. I can have up to 2 combinations of text in a cell, i.e., 'V' or 'T' in this example, followed by a number, that can range from 1-12, i.e., V12T4. What I am trying to do is add up the total 'T' and 'V' time for the month for each employee. Hopefully between what I have written and my attached sheet, will explain what I am trying to do. I know how to write the =Sum(If for using only 1 item in a cell, but not 2.
View Replies!
View Related
Color Code Text Values
Is it possible to use different text colours as part of the [Value_If_True] or [Value_If_False] when using an IF formula? For example =IF(AS3<34,"ok","not ok") In the above formula I would like the “ok” value to be in Blue and the “not ok” value in Red.
View Replies!
View Related
Change Text Color While Combining Cells
Is there a way to combine cells in excel and chage the color of part of it? Example: On my sheet I have multiple cells I need to combine: Say A1 reads 23.65 Say A2 reads 43.65 Now on A3 I want it to read "Estimated budget 23.65 vs 43.65" I can get this to work but here is the problem, I want the 23.65 to always be red and bolded and the 43.65 to always be blue and bolded.
View Replies!
View Related
Conditional Formatting - Finding Text Color
I have a workbook with 4 sheets. Each sheet is set up the same. There are 4 columns. The column headings are Title, Item #, 2009 Retail Price, and Price changed from 2008 (in A, B, C and D respectfully). I need to find all red text in column C and place a 'Y' in column D. If the text in column C is not red I want a 'N' in column D.
View Replies!
View Related
Text Box Properties/font Color
I have text boxes in excel that hold text (obviously) over a period of several days. It gets updated daily, so I want to change the font color for the new text that is added daily rather than all the text. Is there a way to do this? Also, is there a way to get the verticl scorll bar to always show on the right hand side of the text box? The way it is now, I have to click once or twice in the text box before it shows up. I would like the person reading it to automatically know that there is text not presently in view so they know to scroll down for more information.
View Replies!
View Related
Color Cells Where Column X Same Row Has Text
I've got a spreadsheet where there are three columns (a-d) Now B-D contain dates and I'm looking for A to be coloured conditionally so if column B contains any text, then A's background will be red, if A & B contain text, then it'll be orange and if A & B & C contain text then it'll be green. What I can't seem to work out is how to get this to work in this order only - ie my version with conditional formatting means if someone entered text in D and nothing in B & C it'd turn Red...
View Replies!
View Related
Selecting Multiple Items From A List In One Cell.
Is it possible to restrict the values of cells in a particular column to entries defined in a list BUT to allow each cell in that column to display multiple items from the list (seperated by a comma for example). I've attached an example of what I would like to do - In Sheet "2010 Data" I want to be able to select multiple values in column F....(the values are defined within the list named "Platforms" on the worksheet called "Lookups"
View Replies!
View Related
Match & Change Color Of Matching Text Only
I’d like to be able to highlight ONLY the text as shown below based on the look up column. Conditional Formatting will highlight the whole cell, which is not what I want. Is this possible ? Column 1 (Director) director, Robert Rodriguez; producer, Elizabeth Avellan; producer, Robert Rodriguez; writer, Robert Rodriguez Column 2 (Cast) Cast: Leslie Mann, Kat Dennings, James Spader, Jon Cryer, William H. Macy, Jimmy Bennett, Leo Howard, Devon Gearhart, Rebel Rodriguez, Trevor Gagnon, Jake Short Column 3 (Look Up) robert rodriguez james spader
View Replies!
View Related
Validate A Cell To Only Allow Items In List1 Or List2 Or A Numeric Value
I have 2 lists and I want to validate a cell to only allow items in List1 or list2 or A numeric value. List1 D1 D2 D3 .. D10 .. Dxx List2 Hol Off Sick These lists may changein length and number of items the second part, is can you valudate based on other values in a column, basically I have a list of names of available operatives, and I want to make sure each name can only be entered once in a column! Would be even better if I could get a dropdown which showed the remaining choices!
View Replies!
View Related
|
TRACKER
