red

is there a conditional formatting rule I can use that would highlight cells A268:d268 in red if F268 is #N/A? the rows will increase that's just where it's at now. I have a Vookup in column F to look at number in column D and it's #N/A people shouldn't add the information but they still do...

Hello, I'm hoping someone can help me figure out a formula. I am trying to conditionally format when the value of "1" shows up consecutively twice with one color and conditionally format it if it shows up 3 consecutive times with a different color. Here's my example: C4 = 1 C5 = 1 C6 = 0 C7...

Hello, I am building a tab [results]; on this tab, I have a column [column A] which lists a unique value (description). In [column B]; I need to create a formula. This formula needs to look into the [raw data] tab, and count the number of distinct IDs which share the same (description) and...

hi, i have 1 workbook with 2 tabs - on Sheet 1 i need to hyperlink the column COLOR to Sheet 2 with vlookup function. i've tried this but doesn't work. =HYPERLINK(VLOOKUP(B2,'SHEET 2'!A1:B3,2,0) please help me with this. i will need to key in the formula in Sheet 1 B2, and when click on B2...

Hello, I am looking for a formula. I have one tab with raw data, multiple records, multiple duplicates, etc (tab named [raw]). I have another tab [Plan] where I need to insert my formulas. In my reference cell A1; I will enter a unique ID number. I want to use that value I entered in A1 and...

Hello, I have a tab [consolidated] and a tab [adhoc]. I am trying to develop a dynamic formula in [consolidated].F2 to do an Index/Match to the [adhoc] tab and extract a bunch of data. This is super easy without VBA. By writing the code as I do below; this allows me to drag the formula to...

Hard to explain what I'm looking for or if it is even possible. B5 is the cell in which I have any value #.# (ex. 17.2) I have an array of data from J5 to AB5 which different values Another array from J10 to AB10 with different values and so forth Currently these arrays are not one on top of...

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 am using the following code to automate goal seek with an assigned button. Each time I tried to run it I get an error with big red X with 400. Any idea how to fix this? Sub GoalSeek1_Click() Range("E22").GoalSeek Goal:=Range("6000").Value, ChangingCell:=Range("D6") End Sub

Hi I need to have some conditional formatting based on the current time Say A1 contains 07:00 I'd like the formatting to be green if 07:00 Orange when its 07:15 Red after 07:30 is there any way to make it flash red after 07:30 as well? many thanks

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

Hi I would like to format 2 or 3 cells based on the colour of another cell So when the cell goes to Red i want the other cells to have no fill Any other colour and they display their information Help much appreciated

Does anyone know how you can format one digit in a cell without formatting the rest without having to do it manually every time ? For example if 53 appears in a cell I would like for the 3 to be red and the 5 remain black. Every time the 3 appears in my data I want the 3 to be red, for...

Is there a way to change the color of 1 digit in a 2 digit number in a cell? For instance if the number in a cell is 53 I want the 3 to be red and the 5 to remain black, and every time a 3 appears in my data I just want the 3 to be red. So if I type 693 I would like just the 3 to be red and...

Hello! 1st time poster here! I have a manifest of a semi truck that is being delivered. (1500 items at random) Column N is the price Column O is the unique Identifier Formatted blue if over $100, red if under $40, nothing if in between We will scan the unique identifiers as they come off...

This is my first post on MrExcel and I really need a hand... I have a multi team game log where the dates are out of order and the data doesn't contain who played who so each team must be handled independently. I'm trying to figure out win streaks and current streaks "for each" team (Should I be...

Hi, I need help on setting a conditional formula. I need the cell to be colored differently once there is already a gap. Each X represent a column, the first 5 column should be color Red, next 5 X is blue, next 5 X is green. Colors can be anything as long as they are different from each other...

Hey All! I'm in need of help on this macro. What I have it doing is searching the sheet for certain things and copying them over to another sheet. However it copies the entire row (which isn't needed) and I was hoping I could just set it to copy the first 3 columns of that row. The macro is...

Hello all! Have been a lurker for sometime and have found an incredible amount of useful threads here! However I can't seem to find anything that may help me with a notepad to excel macro ( I know theres a few but can't seem to get them to work :( ) So what I am trying to do is pull out Time...