**0**

votes

**1**answer

23 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

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

**0**

votes

**0**answers

8 views

### Comparing two columns in Google Docs [migrated]

I'm working with Google's spreadsheets to keep a record of how many dragons of each breed/gender I have in a game I play. I have five columns:
A (Breed) | B (Male) | C (Male Goal) | D (Female) | E ...

**1**

vote

**2**answers

34 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

41 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

24 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

25 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

53 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

37 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

133 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

22 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

29 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

57 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

52 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

38 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

68 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

56 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

**1**answer

90 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

36 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

156 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

44 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

73 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

19 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

63 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

38 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

195 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

149 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

303 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

116 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

586 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

99 views

### Conditional formatting in Excel 2013 for C8=blue and bold if C5>C2

This is part of a problem for college for which I can't find a solution.
Q: 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

43 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

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

**2**

votes

**1**answer

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

**1**

vote

**2**answers

47 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

**1**answer

35 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

**2**answers

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

**2**answers

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

**-1**

votes

**1**answer

37 views

### Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...

**0**

votes

**1**answer

732 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

**0**answers

33 views

### How to use Color Bar for String Values in Excel 2010

I like to color the backgrounds of the cells which has similar values. There are huge no. of such values so it is not possible to create condition/rule for each. I am looking for a shortcut. Like this ...

**1**

vote

**1**answer

60 views

### Conditionnal Formatting with Dynamic Custom Formatted Date

My problem is that I want to color in red a list Custom Formatted Dates when the date is overdue.
For instance, I got two actions:
Buy Bread : Must be finished before 27/01
Buy Milk : Must be ...

**0**

votes

**1**answer

183 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

**0**answers

254 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

**1**answer

49 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

**1**answer

54 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

**1**answer

96 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

**1**answer

93 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

**0**answers

717 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

**1**answer

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