conditional fomatting

How do you shade a cell based on multiple ranges of data? e.g. A value of... 1 shades red 2-3 shades orange 4-5 shades yellow 6 shades green

Hi, I'm trying to create a output of data with conditional formatting, the basics of this is working fine. However I need to upload this spreadsheet to confluence, which has an issue with conditional formatting. If any cells covered by conditional formatting don't contain data, confluence will...

Hello! I saw a thread wherein someone asked how to apply conditional formatting using an IF statement (http://www.mrexcel.com/forum/excel-questions/348416-conditional-formatting-if-statement.html). I wonder if I could create an IF statement wherein the True portion looks to see if a cell has...

Hi there Is it possible to apply conditional formatting only to used cells. For example if i add a next row it must automatically apply conditional formatting to the new row. Almost something in the line of finding the last row used and apply conditionall formatting over that section.

Hi All, I've got a huge dataset that I need to export out of Excel into a statistical analysis programme. Annoyingly, the stats programme can't deal with the dataset if one of the cells contains a space as a last character (eg, "12345 " instead of "12345".) Is there a way to highlight cells...

Hi, I have a column of due dates then a column of submission dates. I want to highlight entries (that have not been submitted based on the second column) with due dates in 14 days with yellow. Highlight entries not submitted (based on second column) with red that are passed due based on...

Hi there, I hope you're good. Got a problem that has been bugging me for a while, and I wondered if anyone could help. I have a template spreadsheet into which I post a set of data. Each column of the destination spreadsheet has conditional formatting applied to it to detect any issues with...

Urgent help please! I have a GCSE level of knowledge of excel, and I'm working potenial pay for the employees in a company I work in. Some have their pay changing, some stay the same. I need the ones that stay the same to be marked in red on a separte column. I need a rule the do this, not...

Hi, I am using a form control combo box, which returns a number (1-13), depending on what option I've chosen. I then have an index/match lookup for month by month results based on this... My problem is: 2 of the options (5 & 9) are percentages, so I want to format the cells to be numbers when...

I have created a spreadsheet that has 27 columns (but, may add more) and the number of rows is undetermined but, may grow to more that 100 rows. I would like to use conditional formatting to change cell colors based on requirements. This spreadsheet is a shared workbook. I have successfully...

I have one column that contains a monetary amount (column AQ) , and another that contains text reading either "inflows" or "outflows" (column AC) When AC says "inflows", AQ should be positive, and when AC says "Outflows", AQ should be negative. I need the text in column AQ (the monetary...

Hi, I have a formula in a cell which i need conditional formatting. The formula is as follows; =IF(ISERROR(AVERAGEIFS($J$17:$J$34,$A$17:$A$34,"Day",$B$17:$B$34,"PF18")),"",(AVERAGEIFS($J$17:$J$34,$A$17:$A$34,"Day",$B$17:$B$34,"PF18"))) My conditional formatting basically states that; >=$H$39...

Hi, I was wondering if there is a way (official or a work-around) to conditionally format a cell depending not on the result of the formula but on what it did in the process. My particular case is a series of "IF" formulas embed within each other. For example: "If this number is blank, then grab...

I'm currently using a workbook that I edit daily and save on a flash drive to pass on to a co-worker each day for his use. I have Excel 2011 for Mac, and he uses Excel 2010 for PC. On one of the sheets in the workbook, there is a list of contacts with columns A through U containing unique...

A bit of an explanation regarding my workbook. I have two worksheets. The Data sheet containing the table 'Table_Data' which contains ledger transaction amounts and LedgerSummary which contains the table 'Table_Summary' detailing account transaction totals. I use SUMIFS to determine values for...

Hello, Is there a way to drag conditional formatting and have the references change as you drag? I would like C6 to highlight red if both C6 and T6 equal a referenced cell and T6 is not empty. I can do this by writting a rule in conditional formatting that says: =AND(C6=K4,T6=K4,T6<>"") I...

In column B I have a list of mostly names. A few cells contain numbers or are blank. I have to use conditional formating to highlight the cells that do not contain text. Thanks

I am trying to set up conditional formating to colour the cell if for example L10 < E10, but only if data exists in E10 for the entire column(s) the perfect world would be if L10 < E10 only if G10 exists, but that might just be pushing a bit too much

Conditional Formatting cells for text Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am new to this so i apologize if this is already posted... What i am looking to do is conditional format a column to look for several things. <o:p></o:p>...

Hi, I have a range of cells that are the results of an analysis and a second range of cells (same dimensions) stating whether or not the corresponding cells are statistically significant. I would like to highlight the cells in the first range based on whether the corresponding cell in the other...