**4**

votes

**1**answer

2k views

### Excel 2010 conditional formatting: selectively highlighting duplicates

I'm using Excel 2010 and would like to know if there's any way I can choose conditional formatting to highlight only instances of duplicates when it's found in ALL the columns I chose?
For instance, ...

**5**

votes

**1**answer

1k views

### Conditional formatting to highlight the whole row

I would like to highlight the whole row 5 if J5="T".
I used to do it with the old Excel, the 2010 conditional formatting ignores it. So my rule is like this and it does not work. I used the formula ...

**4**

votes

**1**answer

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

**2**

votes

**1**answer

13k views

### Formatting a column based on another columns cell TEXT (not value) in Excel [duplicate]

Possible Duplicate:
Excel 2010 conditional formatting: selectively highlighting duplicates
I have dates that are running off a formula in that column based on information it's collecting ...

**15**

votes

**2**answers

6k views

### Excel Conditional Formatting Escaping a Question Mark

I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn ...

**6**

votes

**1**answer

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

**3**

votes

**4**answers

9k views

### Conditionally format a cell if it contains formula

Is it possible to conditionally format a cell if the cell contains formula (to alert myself and other users when updating the cell)?

**6**

votes

**1**answer

24k views

### Color Cell Based On Text Value

An Excel column contains a text value representing the category of that row.
Is there a way to format all the cells having a distinct value a unique color without manually creating a conditional ...

**2**

votes

**2**answers

33k views

### How to change row color based on a single cell's value? [duplicate]

Possible Duplicate:
Conditional formatting of TRUE / FALSE values in an Excel 2010 range
I have a spreadsheet where I have cell within a row that will contain specific text via data ...

**1**

vote

**1**answer

4k views

### customize excel 2010 highlight track changes

Is there any way to customize how Excel highlights cells on Track Changes? My customer requested us to "highlight anything you've changed by changing text color to red," and I'd like to implement ...

**3**

votes

**1**answer

2k views

### Excel conditional formatting to highlight entire row if one date is not equal to another date in that row

I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...

**3**

votes

**1**answer

16k views

### Conditional formatting of TRUE / FALSE values in an Excel 2010 range

I have a range containing formulas that evaluate to TRUE or FALSE.
How would one apply conditional formatting to this range, so that TRUE cells are Green, and FALSE cells are RED?

**3**

votes

**2**answers

2k views

### Excel conditional formatting based on a formula

I would like to use Excel's conditinal formatting of a particular column based on values in two other columns.
I have values in columns A, B, C and D.
column A has text values (any value user ...

**1**

vote

**3**answers

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

**1**

vote

**1**answer

806 views

### How to compare cell contents in Excel?

I have an Excel sheet. Row number 2 contains date values in each cell. For each cell in the sheet I want to check if the value in row 2 in my column equals some cell (let's say EG67, also dates).
How ...

**1**

vote

**1**answer

265 views

### conditional formatting of entire row from a cell's value in that particular row in Excel 2007

I have viewed the answer for a similar question. If I have several rules for a particular row, (e.g. if cell A2 is 1 then the row is red, if 2 then row is blue, if 3 then row is green, etc...). Having ...

**1**

vote

**2**answers

828 views

### Excel conditional formatting of row

Can someone please tell me how to highlight multiple cells in a row based on some values in any one of a given number of cells?
For example, if in Row 2 any of the cells from D2 to L2 have value "A" ...

**1**

vote

**1**answer

1k views

### Excel 2007 Conditional Formatting is not properly using custom formula provided

In Excel 2007, I want to conditionally color a row if it is odd numbered and then vary the coloring depending on if a specific cell (in column E) in that row contains a number (green) or empty(red). ...

**4**

votes

**2**answers

3k views

### How can I alternate grid background color in excel when a value of a single column changes?

How can I alternate grid background color in excel when a value of a single column changes?
Such as this:
I would want to do this with conditional formatting, but I can't figure out how to.

**4**

votes

**2**answers

11k views

### Alternate grid background color in excel when a value of a single column changes?

I need a formula for conditional formatting to make an Excel 2010 spreadsheet alternate highlighting when a single column changes. This question, "How can I alternate grid background color in excel ...

**7**

votes

**2**answers

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

**4**

votes

**3**answers

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

**1**

vote

**1**answer

1k views

### Conditional Formatting of a Cell Based on Color Value in that Cell in Excel

Is is possible to format a cell based on one component of the RGB value inside of it. For example, let's say I have 3 cells - A1, A2, A3. In A1, I want the cell color to be the shade of red anywhere ...

**6**

votes

**3**answers

19k views

### Microsoft Word 2010 - Conditional Formatting

Is there a way to apply conditional formatting to a table in Microsoft Word 2010, in much the same way that it is possible in Microsoft Excel?
Thanks.

**4**

votes

**1**answer

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

**2**

votes

**0**answers

1k views

### How to copy a column with conditional format by “value” - Libreoffice 4.1

I have a column that contains the data and a set of rules for the conditional format of the cells.
i.e. the conditional format changes the background colour of some cells if they are negative.
I ...

**2**

votes

**1**answer

3k views

### Excel: Conditional Formatting (Highlighting) Values Based on Another Worksheet

I have a workbook that has two worksheets.
The first worksheet is simply a list of the first 78,498 prime numbers in a single column, A1-A78498.
The second worksheet has a grid of numbers from 1 to ...

**1**

vote

**1**answer

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

**1**

vote

**3**answers

16k views

### conditional formatting for subsequent rows or columns

I have data in a range of cells (say six columns and one hundred rows). The first four column contains data and the sixth column has a limiting value. For data in every row the limiting value is ...

**0**

votes

**1**answer

186 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

**0**answers

329 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, ...