red

I want to utilize conditional formatting and need assistance with a formula to use in it. I want it to turn the text in cell M16 bold, red, italic if any of column M equals less than its corresponding line in column F. I know how to write a formula for one cell but not for a whole column. For...

Hello, Looking for some help if possible. I tried to be as detailed as possible Any help would be great! I have a range of data (B2:D4) that has various entries. I would like to find out how many unique entries there are and how many exist for each. Data B2 to D2 = Blank, Gray, Red B3 to D3...

How do I get VBA to look down a column of dates and it the date is less that the date in cell A1 it fills the cell color with red and if it is equal to or 30 days out it colors the cell yellow?

I am trying to identify duplication of words between cells and am hoping this can be accomplished with VBA Here is a sample of the input and output. I am comparing string 1 to string 2. String 1 String 2 Output red orange yellow green...

Is it possible to setup a rule that can highlight a date in column H red if the date does not fall on a Monday or the 10th of each month?

I have a macro that works on my pc perfectly. When I try to run on other users pc I get the same error. Section below in red font is my issue. When I have other users run I get a DEBUG error and the red font highlights in Yellow. (Sorry I couldn't figure out how to hightlight in this website to...

Good Evening, I have a range of cells that are filled with text that is either Green, Amber or Red. If all the cells are Green then the answer is Green, if there is a mix of Amber and Green then the answer is Amber, if all the cells are Amber then the answer is Amber, if the cells are a mix of...

Hi, Wondering if anyone can help or advise I have a sheet that has 3 columns with multiple conditional formatting rules to basically change the cell fill to red, orange or green depending on the date and what is in adjacent cells. The conditional formatting is working fine on my sheet but...

Hi Everyone, Here i have Vlookup which is auto generated by macro, but i need that with dynamic (means table size may vary EVERY MONTH, so the values with red color may change) can anyone help me with this ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-19],'Live Employees'!R1C1:R73C10,10,0)" Thank...

Firstly thank you for taking the time to read. I am tryingto put together a spreadsheet that has simple maths questions, subtraction andaddition. So if I have in cell A1 the number 2 and in cell B1 the number 3 Iwant cell C1 to turn green when the number 5 is entered and similarly if...

<colgroup><col><col><col><col span="17"></colgroup><tbody> I need some help I have a training spread sheet. On the left i have a list of names. The the right of the names i have a series of columns...

Hi - I've been reading a bunch of posts on this and haven't found any that work for me. I have a workbook with a number of sheets. What i would like to happen is what ever value is put in A5 on sheet one will be used to create the worksheet names. So if A5="Red" the worksheets will be named...

Hello, I have a spreadsheet with lots of columns. Some columns need items counted and some need items added. I'm hoping someone can help me with code to count and add cells in a column after the last occurrence of a series of items. Let me explain with an example. The code would start with Col...

Hello, First and foremost, thank you all for helping with my many Excel questions. I use VBA from time to time but I've never used Power Pivot (PP) before. In an effort to get accustomed to PP, I decided to create two simple tables, add them to the data model, create a pivot table from PP on...

Hi, I have a table that is dynamically created. ........S.............T............U...........V 3......apple........45.........24..........red 4......pear..........10.........26.........red ... 12.....banana.....13.........23.........red Column V can be either red or green. A second table...

Hello All! I am quite stuck and I am sure you lovely lot will be able to solve my mystery! So my aim is to find out which cells with a criteria of "Name" & "Date" are red. When a person is late, the cell which is a time, is colored Red. I have names in cells A, and the date in the header...

Below I have written a sequence of #'s in Red. I would like to be able to type in my sequence (usually a 1-20 digit #) and then put how many iterations i would need in Red below that. I would then get my sequence generated in column "A". Thanks in advance to anyone who gives this a shot...

Trying to come up with an IF formula that gets to the "Final Choice" selection in the last column (E). Choice #1 will always have priority over all other choices. Thanks. <colgroup><col span="4"><col></colgroup><tbody> <tbody> A B C D E 1 <tbody> Choice #1 </tbody> <tbody>...

I hope I titled this correctly... I have 10 tabs with data and 1 tab I want to print from that references data from the other tabs. I would like to type the tab name to reference in cell A1 so that all the formulas "know" which tab to look at based on the value of A1. I believe I use =INDIRECT...

Hi I have a column like the one below. I highlighted the cells and then dragged the autofill down. I got all cells value as = "red". Why is that? is it because they are color words. Thank you so much. <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> red black...