**0**

votes

**0**answers

27 views

### Conditional Formatting duplication in Excel 2013

On looking for solutions, some seem to have found the answer ... which unfortunately, does not seem to work for me in Excel 2013 (apparently the issue existed already in 2007... but did not get solved ...

**1**

vote

**1**answer

159 views

### Advanced data consolidation in Excel

I need to Combine/Consolidate Data dynamically between over 20 separate Excel workbooks. The Column names and their relative position at the top row are the same. The positioning of each word under ...

**0**

votes

**1**answer

48 views

### Conditional Formatting with Unequal Row Elements [duplicate]

I have an Excel table. I want to highlight the rows in which at least one element is different from the others for a given row. How can I do that? An example:
PRODUCT COLUMN 1 COLUMN 2 ...

**0**

votes

**1**answer

244 views

### Custom format to display percentage with plus/minus sign

Suppose I have cell value 0.465 and I want to display it in the spreadsheet in green as +46.5 if it is positive and -46.5 if it is negative. I have applied the following format
...

**0**

votes

**1**answer

159 views

### How to use conditional formatting to highlight specific days of the week AND time periods?

This answer regarding formatting on date time information Excel 2010 Conditional Formatting - TIME is a very, very technical answer that, in truth, I don't really understand! Hey-ho, I can deal with ...

**1**

vote

**1**answer

342 views

### How do I use Conditional Formatting based on due dates in Excel 2013?

I am trying to format cells in Excel 2013. I want the cells to get colored as green, yellow, and red based on how close they are with the target date (January 13, 2015 in this case).
I am unable to ...

**1**

vote

**1**answer

59 views

### Conditional Formatting on a Specific Character only

I have the following Excel table :
> N
1 Open / Closed
2 O
3 C
4 O
5 O
6 C
I want to put a Conditional Formatting, putting in GREEN ...

**0**

votes

**1**answer

23 views

### Change background color of rows which are present in another column

I have data in the A and B column. B column's data is mostly duplicates of A's data, but not always. For example:
A
Budapest
Prague
Paris
Bukarest
Moscow
Rome
New York
B
Budapest
Prague
Los Angeles
...

**0**

votes

**1**answer

111 views

### How can I make Excel conditionally highlight cells based on the contents of cells? [duplicate]

I have a few things that I would like to do on Excel:
How do you highlight a row [A-U] if only the first cell A has had text entered in it?
When you enter text in cell A cells B-U have a yellow ...

**0**

votes

**1**answer

23 views

### Excel Title Row — Not part of the count when using conditional formatting

I would like to set my Excel document to color every tenth line in the document using conditional formatting -- without counting the header row as row 1.
Is there any way to accomplish this?

**0**

votes

**2**answers

477 views

### Color scale for text values in Excel

I would like to apply color scale on text values. But unfortunately, it works only on numbers!
I’m doing this to easily identify the repeated values sorted by other column.
This image explains the ...

**1**

vote

**2**answers

178 views

### How do I format cells in one column based off cells in another column?

So I found some similar questions to this already answered here, but they don't go deep enough for what I want to do, and was hoping to find some more help.
At a high level I want to format some ...

**1**

vote

**0**answers

54 views

### Creating a list from another list's value

How can I populate a cell with a list as a result of a condition from another dropdown list?
I have a dropdown list, when I select a value from it I will need to populate the cell beside it with ...

**0**

votes

**1**answer

525 views

### Conditional format cells, based on their text value in Libre Office

This is driving me crazy. I try to set up the simplest conditional rule, but it will not work: format cells based on their text value.
The sense is to colorize a separator line. Until now I had ...

**0**

votes

**0**answers

99 views

### Change value color in a specific column/row/cell if not equal to another specific column/row/cell

I have column A and column B.
Column B's rows contain one of the values A, B, C, or D.
The user needs input in column A any change to the value in column B.
If there is no change, or the value is the ...

**0**

votes

**2**answers

43 views

### Excel 2010 Custom Formula / Conditional Formatting to highlight data that is greater than Twice the Value of Original Cell

I am trying to figure out how to indicate cells that are greater than twice the value when compared to a specific cell. For example, a value of .1 compared to .18 would be OK but .1 compared to .2 ...

**0**

votes

**1**answer

550 views

### Conditional Formatting Cells with Different Values for Rows with the Same Value in Specific Column

I need to conditionally format cells with different values between the same columns, if their value for a specific column is the same.
Scenario
My spreadsheet is a contacts database, where each row ...

**0**

votes

**1**answer

91 views

### Excel 2010 Conditional Formatting

I have a spreadsheet for taskers with due dates. I have used conditional formatting to change the font color to red for pass due and yellow for approaching due dates...now i need to add another ...

**2**

votes

**1**answer

616 views

### How can I use Excel data bars to format cells with text values?

I'm creating a spreadsheet for project planning and have a column that lists estimated effort as follows:
Unknown
Very High
High
Medium
Low
Very Low
None
I like the visual cues provided by ...

**1**

vote

**2**answers

1k views

### How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date).
The chart is printed or worked on at ...

**1**

vote

**1**answer

1k views

### Conditional Formatting if one time is greater than the other

I'm attempting to get excel to conditionally format a cell based on if it is 5 minutes greater than the value in the column next to it. It's to compare times to see if a person was late to work, we ...

**0**

votes

**1**answer

83 views

### Highlight Duplicates Not Next To Each Other Using Conditional Formatting

We have a list of parts in Excel in a certain order. For reasons I won't get into, we need to highlight when there are duplicates that aren't next to each other. Currently, I'm using this formula in a ...

**0**

votes

**1**answer

454 views

### Is there anyway to format negative numbers in red in a table in Powerpoint 2010?

I have tables of data and I want the negative numbers to show up in red (similar to what you would do in Excel). Does powerpoint have this capability?

**1**

vote

**1**answer

108 views

### How to combine data from two sheets and conditionally format rows based on sheet of origin

I have 3 sheets in Excel "Open", "New", "Combine"
"Open" Sheet (Old list)
Ticket ID | Priority | Department | Status
36009 | 1 | Finance | 01-Open
34781 ...

**2**

votes

**1**answer

145 views

### How to apply conditional formatting only to cells that contain a subtotal formula

I have a list of values, I have to alternate color of each row (that works fine).
In that list I also have subtotals, calculated using the SUBTOTAL function.
How would I be able to give just the ...

**1**

vote

**2**answers

11k views

### Excel conditional formatting if value is between or equal to values

I have been trying to use conditional formatting to create a Gantt chart. So far I have not been very successful. Here is a screenshot of part of the chart:
The current formatting is hand made.
I ...

**2**

votes

**1**answer

28 views

### How to show a value of a Cell as it's displayed

I have a cell A2 that shows the value 001. I want to concatenate that value of 001 to a string to show REQ-001. The cell that I want to show this string I have =CONCATENATE("REQ-",A3). But the ...

**0**

votes

**0**answers

53 views

### Formatting of entire column based on the grand total using color scale?

This might be answered somewhere else, but I haven't been able to find a solution to this. The question is how to use color scale for entire column just based on grand total.
I have attached the ...

**0**

votes

**0**answers

215 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 ...

**1**

vote

**1**answer

151 views

### Excel 2013 - Problems splitting cell containing two decimal numbers

I need to separate values that look like this and are in one column in an excel spreadsheet.
48.116667, 11.55
I though this would be easy and did this: Select the column, click on (Data Ribbon) - ...

**0**

votes

**1**answer

64 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

**0**answers

223 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

**0**answers

64 views

### Excel 2011 conditional formatting, problems w/ adding deleting rows [duplicate]

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

**1**answer

301 views

### A formula to check if the date is older or equal to 60 days and another columns cell is equal to a value

I have tried using conditional formatting and managed to get the first part of the formula to work.
=D2:D999<=TODAY()-60
I want to then also check if the value of what is in column G is equal to ...

**1**

vote

**1**answer

44 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

**1**answer

1k 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

**2**answers

117 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

**1**answer

105 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 ...

**1**

vote

**0**answers

30 views

### Excel for Mac 2011 - Conditional Format - Look inside formula for sheet reference

I would like to use conditional formatting to locate all cells on a large sheet (Sheet 1) that have a reference to another sheet (Sheet 2) within a formula in a cell on Sheet 1. I was hoping I could ...

**0**

votes

**2**answers

137 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

**0**answers

61 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

**2**answers

1k views

### Excel 2010 Conditional Formatting for a range based on “Less Than” and “OR”

How do I use conditional formatting on a range of values such that every third cell should be filled with a particular color if the value entered in that cell is lower than values in any of the three ...

**0**

votes

**0**answers

1k 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

**2**answers

6k 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

**1**answer

249 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 ...

**1**

vote

**3**answers

1k 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

**1**answer

241 views

### Conditional formatting in Excel 2013 based on inequality between two cells

This is part of a problem for college for which I can't find a solution.
Use conditional formatting to format, in blue and bold, the value in column 8 for which the value in column 5 is greater ...

**0**

votes

**1**answer

146 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 ...

**0**

votes

**1**answer

2k views

### How can conditional formatting be used for duplicate cells on different sheets?

I have set up multiple tabs on excel 2013, I have created a conditional format to highlight box red when duplicate information is entered. However I would like this also to happen on the different ...

**3**

votes

**1**answer

113 views

### Excel 2013: Conditional Formatting changes after Query has run

I have conditional formatting on Columns A to N. Columns F to N are updated every time I open the spreadsheet as it pulls info from a SQL script. The problem I'm having is the following:
My ...