green

***THIS HAS BEEN SOLVED - MY APOLOGIES*** I'm looking to format a cell based on its value versus the value of another cell. I know how to format cells based on comparison of cell values, but my problem is I'm not sure what the formula would be in my instance. My scenario is that I want to...

Hi all, I got below table where I want to extract the first date in the top row under the condition that the green row is not equal to zero anymore. Which formula would you advise to use? Thanks!

Hello, i'm after a way to change a cells color based on the value of that cell in relation to the value in an adjoining cell. essentially what the actual value is in relation to the target value. if the actual value cell is lower than the target value cell then i want it to turn red, and green...

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...

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...

Hi I am trying to apply conditional formatting to a column of cells. Basically i have data in columb b and column C. What I want to do is highligh all cells that are greater than there adjacent cell to highlight in red and lower to highllight in green I can get it to do it for the first cell...

Hi, I am looking to use CF to show how many working days have passed from TODAY RED - 3 or more ORANGE - 2 YELLOW - 1 GREEN - TODAY Any help appreciated Thanks

Good day, I have cells when selected it gives a drop down and opens the calendar and a date can be selected in that cell. When the date is selected i am trying to let the cell change color green if the date is in future and show red when date is in past, basically showing next steps when it is...

I set up my conditional formatting to turn text green if equal to or less than 5.25 and red if greater than 5.25. No matter what number shows up in the cell, they are always green. This cell is a percentage if that matters. I went to another cell to test it on a simple one, but not a...

Hey All, I'm trying to track what games friends have vs what games I have, etc, so I decided to use Excel and make a list, etc. Then when the weekend comes I can just look who is around and decide on a game we are playing. When I do a drop down list to allocate the game names to the person...

I am not a beginner, but certainly not an expert so maybe someone can help me. Right now, I have the below Formula in column S and it is working like it is supposed to. In column S, it will populate the word "Red" "Amber" or "Green" based on the difference between the 2 dates in column H&I...

Hi All I need to sort column A first by the lowest number. Column A is always a number.Then by Column B and is always a word with many duplicates. Example: Sheet 1 _____A______B 1____21_____Red 2____22_____Red 3____23_____Red 4____103____Green 5____104____Green 6____105____Green...

I have two tabs on my spreadsheet “green” and “blue”. Muchof the content is identical but has been sorted for numerous reasons. The blue tab is where my destination cells are and where theformula should go. I need a formula for P2 that looks at D2 and compares it toD2 – D120 on the green tab...

Good morning I have a 3 year training cycle and have been trying to use the "ICON SET" Red, Amber, Green flags in boxes alongside the date to highlight as follows Red when the training is out of date or past 1065 days from today's date so have tried =TODAY()-1065 in the formula box Amber...

I'm making a call to a public function declared inside a referenced Add-In. The function works fine, but I'm getting the dreaded green triangle for the all the cells in the column of my table. The option to "Restore to Calculated Column Formula" or simply re-inputting the formula removes the...

I am looking for the most efficient way to take a two column table of data and convert it into a multi column table of only unique rows based on the value of the first column (see simple example below). Can be a VBA script or formulas. I am working with data that starts at around 10,000 rows of...

Hello everyone, Here is my issue, I have column of data that I'm scanning using the find feature to see if the number I scanned has a match in the column. Currently, I'm highlighting the cell green manually if it is a match. I've searched the forum and tried multiple ways in conditional...

Hi, Can someone please advise me how to use conditional formatting when you want to use to conditions in the same formula. Effectively a 'And' statement. So I want Team A below where it shows May 60% to be 'Dark Green' in conditional Formatting. The formula is in the 2nd table is the May value...

Hi all, I'm really confused by an issue i'm facing with 2 simple conditional format rules on a single cell (H6): Cell Value - Equal to - =0 - Green fill Cell Value - Not Equal to - =0 - Red fill When I apply these to H6, the cell is always Red regardless of value, even if I delete the not...

Hi, I'm trying to find the first green colored cell in a column, and then return the value of the cell directly to the right. E.g. if first green cell was A2, it would return the value of B2. Any help on this would be greatly appreciated! Cheers, Sinko