red

Hi, On my worksheet i type in a customers name in the cell A6 I then go to the cell B6 to complete the next set of values to input BUT when i leave the cell A6 a code checks to see if the customers name already already exists in column A. If nothing is found i continue like you would BUT if the...

Looks like Excel's conditional formatting only has a green arrow up, but I need something to indicate increase cost, by using Red Arrow. I've tried the Char and UNICode and some give me those arrows, but there is no way to color code them? Any thoughts would be appreciated! I am just using a...

I have looked and tried, and no luck. I need A3 to do 2 things When the arrival date is less than the number of days allowed to turn red. so it will turn red when a date is entered and also turn red automatically using today's date. A1 has arrival date A2 Has drop down list with 1 day, 3...

Hello all I'm looking for a little help with a formula I'm working on <colgroup><col width="64" style="width:48pt" span="18"> </colgroup><tbody>...

I need the below to read White, Blue, Red & Silver. I have used the =SUBSTITUTE(B4," &", ",",1) to remove the first one, but I can't figure out how to remove the second &. Please help. TIA <colgroup><col width="64"><col width="203"></colgroup><tbody> ADJ4 White & Blue & Red &...

Distribute Black text values of excel as compared to Red Text values, In the below example I want to distribute 45+15 = 60 among 1,3,4,5 but the sum of 1,3,4,5 is 66 so it can distribute the values up to 60 It will choose to distribute the values from Max values to Min values, so I want the C...

Hi! I have a sheet with a lot of comments which show additional information. With al the red right top corner triangles for every comments it gets very messy. Is there a way to not show these indicators? I found the 'no comments and indicators' function in Excel but this automatically removes...

Hello to everyone, I was wondering if there is any VBA code or Conditional Formatting for changing the Fill Collor of a cell after I wrote in it. The trick is that I want this to work with a timer. What I mean is that at midnight the cell to become filled with red color and after I wrote...

I have worksheet of employees for salary sheet calculations. This worksheet have date format need to get every month dates automatically which currently put manually. also days put from past link of whole date each cell's same value to left side of every dates and changed its format to show...

Hello, My current raw data table reads: Monday Tuesday Black Red Black Red Car 10 15 6 7 Horse 4 2 2 6 Bike 7 3 4 5 Wagon 8 1 5 3 Is there any way to pivot this and have the filter as the...

Hi, I was just looking for a basic code that when i select a cell it would turn Red. When i leave that cell & select another it would revert back to its original colour & the new selected cell would then take on board the red colour. What i am finding is this. My whole sheet is yellow. I select...

I do a Financial Spreadsheet for my boss. Lets say A1 is our revenue. B1 is staff cost. C1 is a percentage of cost to revenue. D1 is the difference of C1 to our Goal of 22.5% Is there a way C1 can turn Red if the Percentage exceeds our Goal of 22.5? Is there a way D1 can be Red if the...

Hi all, I´m looking for a code that changes in all the workbook, all the text that is in red colored (red font), into black (black font). Would it be possible? Thanks in advance!

Hi I am trying to figure out a concatenated hyperlink. =HYPERLINK(CONCATENATE("[CSUL.xlsx]",A12,"!A7"),"Goto") This is what I have got so far it links to the workbook CSUL.xlsx but not the Sheet and Cell. The sheet name is in Cell A12. I think this is a problem with Parenthesis. If not...

Hi there, I am very new to this but I would like to seek your views on how to go about doing this. What happened is I have 5 different worksheets which call the same thing by different names. For example, 1. Worksheet1: apple 2. Worksheet2: applie 3. Worksheet3: green apple 4. Worksheet4: red...

Thanks in advance for any suggestions for which feedback will be given. Why is the following VBA Code actually bolding the cell and filling it in red when the cell is 1 or 3 for column 13? It is meant to say if j = 13 and if the value of the cell is not 1 or 3, then make it bold and fill it...

hello all at work they like to use colours to indicate a value red = 3 green = 2 yellow = 1 is there a formula that if the cell is red = 3 so what I'm after is, if A1 is red in colour in B1 the cell = 3 formula = if red= 3, green = 2, yellow = 1 please help if you get what I'm on about...

Hi all: I have data in sheets(data), I want macro to do that: 1. Minus value Column(D,E,F,G,H,I) with column(M,N,0,P,Q,R) like this: Si = Di - Mi Ti = Ei - Ni Ui = Fi - Oi Vi = Gi - Pi Wi = Hi - Qi Xi = Ii - Ri 2. Check value row i = 1 to last row that: if Si<>0 or Ti<>0 or Ui<>0 or Vi<>0 or...

<tbody> Names John 5 6 8 4 James 7 2 2 4 Mike 5 5 7 7 Jeff 6 3 7 9 </tbody> If a person's row has a 5 in it, I'd like to have their cell highlighted red. So the end result should have John's and Mike's cells highlighted red

we have a spreadsheet with six columns. The cells in the six columns have conditional formatting and change color based on the value in them. Colors are red, green, and yellow. I want to count the number green and yellow cells in a row. Can this be done? Below is an example, except the...