0
votes
0answers
27 views

Update conditional formatting cell references when conditional formatting is applied to new cell

I am applying conditional formatting to cells on my spreadsheet, using the following formula in cell C6: =INDEX('All Time'!$F$2:$F$550,MATCH(INDEX('All Time'!**$A$7**:$A$550,MATCH("*",'All ...
0
votes
1answer
24 views

Conditional formatting

What I am looking to do is have a conditional format set up so that if row G contains the value "In progress" "With 3rd Party" or "Identifying" and row H, J or K contain no value then highlight rows A ...
0
votes
0answers
16 views

conditional formatting of pie chart segments

i have a very simple pie chart - developed in excel for mac 2011. each segment of the chart represents a 'group' and is sized relative to a column of data called 'count'. there is a second column ...
1
vote
0answers
32 views

Excel 2011 conditional formatting, problems w/ adding deleting rows

I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row. The form varies wildly in length. Currently, I am using conditional ...
1
vote
1answer
30 views

Conditional formatting excel conundrum

I have a list of values in excel. I would like to highlight a cell if its more than 1.5 higher or lower than the value before it or after it. Is this possible? Thanks guys!!
0
votes
1answer
51 views

Conditional Formatting for one cell value in a list, another cell blank

Looking for how to do Conditional Formatting for the following rule: If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. ...
0
votes
2answers
28 views

Excel Formating - How do I compare 2 cells and highlight one of them based on the date in 1 Col being further out then the date in the other?

I have a spreadsheet tracking multiple dates for about 150 people. I am having a problem however getting dates in Col I to highlight if they are going to be past the date in Col P. I want Col I Row ...
1
vote
1answer
59 views

Excel: Different background colors on condition

The problem I have a Excel sheet that contains a status column. Number Status Name ------------------------------------- 1 not implemented feature 1 2 completed ...
0
votes
2answers
46 views

Selectively find duplicates across columns

Column A has the product ID. There are 102 other columns with other data. Column A will be unique unless some data was changed. In that case, there will be 2 rows with 99% of the columns are ...
1
vote
0answers
33 views

How to search Excel conditional formatting formula with specific text

Sorry I did try to search but could not find a question similar to what I want. My Question: Is there any easy way I could search all conditional formatting that has formula with specific text? I ...
0
votes
0answers
71 views

How to use a color coded drop down in Excel across multiple sheets?

I have seen a few examples on how to create a color coded drop down in an excel spreadsheet. An example of what to do can be seen here. ...
3
votes
2answers
142 views

Highlighting Cells in Excel based on the Value Associated with the Cell

I have two sheets: Users in their respective groups and A compilation of those same users with an expiration date. I'd like to highlight any cell in the the first sheet if their respective date ...
0
votes
1answer
84 views

Excel Conditional Formatting: 3 color scale scoring fuzzy matched data for Windows [duplicate]

This question is posted as a spinoff from here - the post cited is about Mac where as this is about Windows: Conditional Formatting: 3 color scale showing text relevance in Excel for Mac Is ...
0
votes
3answers
234 views

Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac) I want Cell B2 to be green when A2 says "John likes green ...
0
votes
1answer
24 views

How to suppress repeating values in a manner that takes into account previous conditional formatting? (Google Calendar-like scheduling blocks)

I'm in the process of creating a scheduling template. I'm trying to figure out how I create a conditional formatting formula for suppressing repeating values that takes into account the conditional ...
1
vote
2answers
41 views

conditional formatting excel 2013

Is there a way to highlight a cell (possibly with conditional formatting) if one of the cells to the left of it has data, but it is empty? for instance, A B C D ...
0
votes
1answer
27 views

Conditional formatting in Excel 2013

Hi I want use conditional formatting. On this values: everything works, but when i change values (mid and max values are similiar) to: conditional Formatting do not works. What I do bad?
0
votes
2answers
776 views

Correct use of the Formula type in Excel Colour Scales

I'm trying to work some trickery in excel where each cell in a row is shaded based on how many have been completed: So the idea is that as more of the columns in the row are ticked the whole row ...
0
votes
2answers
44 views

How to put conditional formatting in a cell from another excel worksheet [closed]

It's hard to describe what I want, I'm not really familiar with Excel condition terms but it is basically just like this: Worksheet= Dr. castro patient consultations A B C D E ...
0
votes
1answer
491 views

How to format cells between two dates with a colour based on a value in vba?

(apologies if this question is difficult to understand, i'm unable to post an image) I've tried finding a solution for this online but haven't had much luck. Ideally, I want to use conditional ...
0
votes
1answer
121 views

Automatically format currency based on adjacent column - Excel

Using Excel and need a little help with a simple formula. I know conditional formatting should do the trick here, however, I need help creating the exact formula for my need. In column A I write the ...
0
votes
0answers
204 views

VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below). Please note that: Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table' The number of columns, ...
0
votes
1answer
46 views

How can I set up this conditional formatting in Excel 2010?

We create sections by highlighting an area in Excel 2010 and clicking ALL BORDERS. We want to set it so that any time you type "REPLA" between columns J and Q, the line that "REPLA" is in will Fill ...
0
votes
1answer
51 views

Is it possible to get array/CSE formulas to work with conditional formatting?

I am trying to get a CSE formula to work with conditonal formatting. When using CSEs with cells, you hit CTRL+SHIFT+ENTER, but it appears that this key combination doesn't register in the conditional ...
0
votes
1answer
90 views

How to change a row of cells on excel 2010 depending on different cell data

Can anyone help me with a problem I'm having on excel 2010 please? I am trying to change the colour of part of a row of cells when certain data is input. For example I want cells A13 to G13 to ...
1
vote
1answer
77 views

Conditional formatting from another conditional format in Excel

In Sheet X I have a bunch of cells that are conditionally formatted with a fill color. I want the colors from Sheet X to be dynamically updated to Sheet Y and Sheet Z. That is, if cell X:3:D is ...
3
votes
0answers
524 views

Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table

One of our users uses pivot tables a lot. She often called me about Excel crashing from time to time without being able to reproduce the problem. Today we have found a way to reproduce the crash every ...
0
votes
1answer
100 views

Excel - Using condtional formatting in a count down of the date

So i am using Excel Mac 2008, i want a formula where i enter a date and if the date is less than 5 days from today, it turns bold and red. can anyone help me figure this out? I have a formula that ...
4
votes
1answer
270 views

Excel: Dual graded color scales

Is it possible to do conditional formating for two graded color scales over the same cells? For example I wish to conditionally format a cell such that its color is: Green to Blue graded scale for ...
0
votes
1answer
55 views

Conditional formatting duplicates for highlighted cells

I would like to conditionally highlight cells in a row. When the items in column B are duplicates then cells in columns B and C should be highlighted. The value 7264 in column B has duplicates so ...
1
vote
2answers
1k views

Preserve conditional formatting on cut-paste

I have some data from different sources that I'm trying to line up to get a good handle on which fields they have in common and which they don't. To make it easier to see rows, I set up a conditional ...
6
votes
2answers
3k views

How do I keep Conditional Formatting formulas and ranges from automatically changing?

I've found that Conditional Formatting formulas and ranges will automatically adjust when you copy, delete, or move data around in a spreadsheet. While this is a nice idea, it tends to break things ...
0
votes
0answers
14 views

Conditional Formatting for entire ROW based on a cell entry number in a particular column [duplicate]

I am looking for how to have conditional formatting for a row if a certain cell has a certain number in it. If a cell in column J has the number 284 in the cell, then the whole row (cells A - J ) ...
1
vote
1answer
234 views

Change Excel Worksheet background colour based on values

Hopefully some one can help, but not sure if its possible. I'm using Excel 2010. I want to change the background colour of a whole worksheet to green if the value in cell c20 is equal to or greater ...
0
votes
1answer
85 views

How do you have a conditional formatting rule in Excel apply to a discontiguous range of cells?

I have an Excel workbook with 10 worksheets. Each sheet has a column named status. Depending on the value of status ("on time", "at risk", "completed"), I want to format the cell background with a ...
-1
votes
1answer
3k views

Changing a row's color depending on the value ( TEXT ) of a cell [duplicate]

In a cell, I have the choice of YES and NO for values. I would like to know how to change the background color for other cells in the same row depending on the value of the first without changing the ...
1
vote
1answer
404 views

Conditional formatting for entire row based on fixed column

How do I create the following conditonal formatting: If the date in G3 is older than today, turn all of row 3 red So in other words I want my entire row to be formatted based on the value in the ...
0
votes
3answers
2k views

For Excel how do I create a field that automatically generates a sequential number

How do I create a field that automatically generates a unique number when I enter a new record in a table ? I have a list of numbers in the B column. I want the numbers in column A to automatically ...
2
votes
1answer
366 views

Excel Conditional Formatting cell's value that has number suffix, like 99th, 23rd, or 1st

So I am filling a cell with Blue, Green, Yellow, or Red based on a Percentile Rank that is returned, that is numbers like ( >=90th=Blue, >=60th=Green, >=30th=Yellow, <30th=Red ) Currently ...
0
votes
2answers
369 views

Conditional format cells that are duplicated in every column

I have a table in which every column describes a product and every row is responsible for one attribute of the product. I want to highlight cells which are duplicated in every column. I have for ...
4
votes
1answer
317 views

Excel conditional formatting fragmentation

Often, I create a sheet with conditional formatting, and set the cell ranges so that the conditional formatting rules are only applied once to a range of cells, e.g. Make $A$1:$A$30 red and Make ...
1
vote
1answer
456 views

Excel conditional formatting based on a formula including a range containing the current cell

I want to change the background of a cell as long as the running total in that column from start to that cell is less than a limit specified in a different cell. Conceptually, the formula should look ...
0
votes
1answer
858 views

Conditional Formatting - Highlight An Entire Row by Comparing Two Cells of a Column

I've dug through the questions on this site and they address both problems I have, but separately. I've been trying to combine the solutions for a couple hours with no success. Basically, I would ...
1
vote
1answer
8k views

Excel: Conditional formatting using icon sets?

I would like to format the Subtotal row such that within each Subtotal cell is the total and an "icon set" icon that will show if that month is greater than or less than the previous month's total. ...
1
vote
2answers
55 views

Single condtional format rule to apply to a range of cells

I'd like a single conditional format rule I can apply to a range (a columns) so that a number appears in bold if it is greater that the number to its left, like this: 100 200 200 190 200 300 Is ...
2
votes
3answers
4k views

Is it possible to save conditional formatting rules for reuse in a new workbook?

I want to make some rules that I can haves saved that I can easily apply to new workbooks as needed. It's a pain doing it how I currently do where I'm always having to go back through and recreate ...
-2
votes
1answer
96 views

Conditional date formatting

The following needs to happen: Enter a goal date in cell C1 and enter actual completion date in D1 when project complete D1 will remain blank until project is complete. If D1 is blank: STATE 1 -- ...
0
votes
1answer
155 views

Excel cell formatting to fill color

I'm doing some excel formatting, with below formula being used: =IF(OR(ISBLANK(E23),ISBLANK(E24),ISBLANK(E25)),"Section Incomplete","Section Complete") Basically, When the cells E23, E24 and E25 ...
6
votes
1answer
4k views

How to conditionally create a hyperlink based on value of a cell

ColA Col B ColC Project A A.pdf A.pdf Project B No Link I have a list of project records. One column (e.g., B) ...
2
votes
3answers
845 views

How to format a date field based on whether the date has passed?

I am trying to create an Excel spreadsheet where, when I input a date: if that date is within 30 days it will go yellow, if the date has already gone then it goes red, and if the date is more than ...