conditional formating

I'm trying to apply conditional formatting a number of rows using a formula. The formula looks like this: =NOT(ISBLANK(J20)) which applies to cell F20 I now want to fill down this conditional formatting so that =NOT(ISBLANK(J21)) applies to F21 and so on. However, when I try to do that, the...

A1= STYLE A A2= STYLE B A3= STYLE C A4= STYLE D A5= STYLE E A6= STYLE F A7= STYLE G A8= STYLE H A9= STYLE I A10= STYLE J B1= 304 B2= 111 B3= 205 B4= 316 B5= 524 B6= 308 B7= 209 B8= 116 B9= 415 B10= 420 Conditions: STYLE E can only be a 401, 402, 403, 404, or 405. I want to use conditional...

I need to know how to find if a cell has conditional formatting applied, or the reverse, there is no conditional formatting applied. In Cell a2 enter yes if Cell b2 has conditional formatting if not enter no. Ultimately The A2 will be used in other formulas, to count how many yeses there...

First time poster, long time reader, thanks for all the past help and on this question... I have a doc that several other employees use and one field requires users to input a Unique Name. The Unique Name can only use Letters and Numbers though, so I'd like to do conditional formatting when a...

Hi I'm using the following formula... =2=COUNTBLANK(INDIRECT(CHAR(COLUMN()+62)&ROW()&":"&CHAR(COLUMN()+64)&ROW())) To check 2 cells to the left of any given cell and if they appear empty change the colour of the cell. It's been working perfectly, however I've now reached column 'AA' and...

Hello, first time poster but long time reader of this forum, it has been a great help! Okay... I have a column of dates and have colored the rows by days of the week using conditional formating based on formula "=WEEKDAY($B9,1)=7" and applies to a range of "=$B$9:$BR$55" Next I want to sum...

I've created a PowerView based on a merged Power Query. Basically I've taking Actual hrs, Estimate At Complete (EAC) and Budget hours from several different sources and linked them by Work Breakdown structure (WBS) in a merged Power Query. I then used PowerView to display the data in a table...

Hello and thank you for taking my inquiry. First time post. I am very new to Excel so please bear with me. I have a column and row with 100 postal codes. I am trying out CDXZipStream to calculate the distance between each and every one of those postal codes (100X100). By using an Index / Match...

I am using Excel 2013 I have one spreadsheet that is giving me issues on my new laptop. When I go to: Conditional Formatting - Manage Rules I get an error message: Not enough system resources to display dialog It is only on this spreadsheet. I have larger spreadsheets that dont give me any...

Hi there! does anyone know how can I create an icon set using conditional formating, I'll like to modify size and color? There is an icon that tackles size but i have no idea how to change the color on the icon Thx!

I have created a table by keying in some row headings, some column headings and some data, then doing Home, Styles, Format as a table. Over the last few weeks I have added more rows and columns. I few days ago, I added some conditional formating to columns N, O and P. Then I added a few more...

Hello, I would like to use Excel color scale to do a conditional formatting on some cells. If the cell value < 0 --> cell color is red If 0<=cell value <1 -> cell color is a gradient chaging from red to yellow If the cell value is 1 --> cell color is yellow If 1< cell value is <=2 --> cell...

Hello all, I currently have a set of data under 3 row headings and the columns are the weeks. I would like to show an arrow beside each weeks data to say if it has increased or decreased from the previous week. Any help would be greatly appreciated. Thanks

This sheet monitors individual's physical fitness scores. If members score <90 they must retest every 6 months with a diagnostic performed two months prior (4 months mark). If they score 90 or higher they will retest yearly with a diagnostic performed at 10 months. I have several rows of...

I am trying to set up conditional formatting for a report that i have to submit showing the status of invoice payments from our clients. What i want is for a cell to change to colour amber 5 days before the invoice due date; red when it becomes overdue; and green when the payment date is...

First off, I know, merged cells are the Devil and should be avoided at all costs. :diablo: That said, I have no choice but to deal with them in this spreadsheet. I get a daily Excel product, which is generated from a third party system. I then have to make multiple formatting (color code, hide...

Hi I hope you can help. I'm trying to highlight a range of cells that fall between a range (>41) but only if the time in the adjacent column falls between two times. The sheet shows tidal ranges and I want it to highlight tide values above 41 (column B) but only between the hours of 09:00 and...

Hello, and thanks in advance for the help. Using Excel 2010 on a Windows 7 machine. I have a list of about 4000 items (products). I want my salespeople to be able to run through the list and quickly identify which items are being purchased by a customer. I have already created the...

Hello Everyone, I am actually stuck with the below language formatting or look up problem. I have a Table with values in Number in two different language. <tbody> A B C 1 94 ৯৪ ৯৪ 2 22 ২২ 22 3 55 ৫৫ </tbody> I have created a drop down with two languages. now, I want to do a simple if...

Excel 2010, 32 bit OS, dual core, 4G RAM One of our team has a fairly large spdsht that has one page with a large number of conditional formats applied to it (the range containing the formats is currently 66 columns and 1655 rows, with a conditional format for every column). His process is to...