conditional formating

I have a spreadsheet where i want to search for the word "Total" in column headings, then look down the column that matched for "Total", find any row that has a value greater than 1 and highlight the row. The reason for searching for "Total" is that more columns may be added at any time but...

Hi, So I am doing inventory and one column is for inventory on order and inventoy in stock. A B C D 0 4 4 6 When A+B is <=C, I want either the entire row to highlight or cell A1,B2,C3,D4. C is the minimum number of inventory and D is how much to order when they've reached the...

I need the formula to automatically add 7 years to a date to get the expire date of a product. Column C is my purchase date and I need a formula to add 7 years to my purchase date and place the new date in column K. Column K is the product expire date. My date format is 5/30/2014. Example: once...

I am new to the forum and I need technical help desperately. I need a formula to deal with 3 columns of data all on the same row on my financial spreadsheet. Column E contains dates of receiving interest income entered in this way "5/30/2014". Column F contains the interest earned amounts...

Hello! I am using the forum some time now but just registered because I tried some suggestions already posted but no luck :( I have a column in Excel 2013 with certificate Due Dates: If the certificate overdue: Red If the certificate expires in 90 days/ 3 months form today: Yellow (for those...

Looking to create a conditional formatting code that would allow the following to occur: IF the data in column B1 contains "//UDMN" THEN populate column A1 with state code "MN" I have a list of several (really it's a table) that has this listed out where it shows others such as "//CEFL" = FL...

I want to use a formula to highlight cells which have a Size in one of the columns AND where the QTY is blank. A B 1 Size Qty 2 MD 1 3 SM So in the example above, B3 would be automatically highlighted since A3 contains a size but B3 does not contain a...

Hello I have this formula for conditional formatting to highlight a row: =AND(OR(COUNTIF($D$5:$F$8,$D5:$F5)>=2),$G5<>0) If any of the values on the row is reapeatead in the range and another condition is true then highlight the row, the thing is I only know where the range begins, the end...

Hey All, I have a matrix with conditional formatting of some values that looks like this: http://1drv.ms/1xx9Ckr http://1drv.ms/1xx9Ckr then I want to add some other data to the fields (standard deviations, and descriptors) so of course the conditional formatting is now stripped out...

I'm looking to apply a cell highlight to all intersections where the row and column heading match. The data set will be a pivot table, but if this prohibits the application of formatting I can work with a table. Solution needs to be Excel 2007 compatible. An example of what I'm looking for...

Hi Excel VBA Gurus! H.E.L.P. P.L.E.A.S.E Am new here and hope someone can help, I am literally pulling my hair out. :confused: I have searched and searched and not come up with a solution and cannot explain what is happening. Basically I have a worksheet in Excel 2013 (on a Win 7 X86...

Thank you in advance for your help. I am new here. I have created a grid view of a schedule to make it easier for people at a trade show. I have a tab for each demo station/conference room with the data to be collected and a status field. Demo Station/Conf Room Sheets...

Hi, I wish to colour code my bar chart. I have a range of codes which I wish to give an individual colour when it is represented on the bar chart. E.g codes beginning with 123 = Red, codes beginning with 456 = blue and so on. I know how to conditional format cells, but i'm unsure on how to...

Hi, I have a large workbook with certain groups of cells (defined by filters) and want to apply different conditional formats based on those ranges. For example: A: B: Region 1 10/02 Region 3 12/04 Region 2 15/03 Region 1 11/02 Region 2 12/03 Region...

I have a number of spreadsheets which are similar and so I copied one from another. I had the same problem that many people have had about links to previous spreadsheets (the ones I copied from). I searched the internet many times and looked to solve the problem like searching for “ [ “ and...

Hi guys, I've been working on a spreadsheet for some time now and looked through several forums and threads to find an answer, but cant find any at all. The sheet is more or less like a gantt-chart with activities down column A and duration/weeks along the rows http://tinypic.com/r/xnfb6p/8...

Hello, I have been trying to work on this with conditional formatting for a couple of days now to no avail :( Here is a photo of the chart I'm working with: I have made it so that every time a "FILE NUMBER" is entered the cell to the right in grey shows the date it was entered in dd-Mmm-yy...

I need help finding a way to highlight rows while doing a conditional format for the unique values of a column. For example if column had the values 1 1 2 3 3 I would want the entire row 3 highlighted. Also if anyone knows a way to write a macro do the conditional format across workbooks that...

Hi, I'm trying to formatting a number of cells (eg E5 to H5) to go grey based on if Yes appears in a separate cell (D5). The formulas I've used so far haven't worked: =D5=Yes & =COUNTIF(D5='Yes') Can anyone help me out please? Thanks

Hi, I am trying to apply the conditional formatting to a column D in a spreadsheet. I need the following: If there is a value in a cell A1-the cell D1 needs to be filled with yellow, if there is a value in a cell B1- cell D1 becomes red, if the value in cell C1=100%, D1 becomes green. I used...