**38**

votes

**8**answers

183k views

### Find Items in one column that are not in another column

I have two columns in Excel, and I want to find (preferably highlight) the items that are in column B but not in column A.
What's the quickest way to do this?

**29**

votes

**2**answers

46k views

### How to color rows based on cell value in Open/Libre Office

How do you automatically set the background color of an entire row based on the value of a specific column in that row in Open/Libre Office? There are similar questions for Excel, but this doesn't ...

**27**

votes

**2**answers

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

**14**

votes

**3**answers

90k 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 cells having a distinct value a unique color without manually creating a conditional format ...

**12**

votes

**4**answers

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

**9**

votes

**2**answers

2k 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 $B$...

**8**

votes

**5**answers

25k 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)?

**8**

votes

**1**answer

43k 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?

**8**

votes

**3**answers

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

**7**

votes

**3**answers

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

44k views

### Excel Conditional Formatting if one column equal to another

This should be the simplest example of conditional formatting but I can't figure it out. I havave two columns seperated by several dozen other columns ('C'-original data, 'BO'- calculated value) and I ...

**7**

votes

**2**answers

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

**7**

votes

**3**answers

18k views

### Excel 2007: Conditional formatting so that each row shows low values yellow, high values red

I have a spreadsheet with approx 300 rows. Each row has about 15 columns, and each cell contains a numeric value. Each row corresponds to a product.
I want to get Excel, for each product, to ...

**6**

votes

**12**answers

64k views

### How to prevent cells from printing in Excel

How can I prevent the contents of specific cells (or entire row or column) from printing in Excel, while keeping them visible on the screen when I'm editing the file? Ideally I should be able to do ...

**6**

votes

**1**answer

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

**6**

votes

**3**answers

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

**6**

votes

**2**answers

7k views

### LibreOffice conditional formatting based on string value: strange behavior

Here is what happen when I apply conditional formatting:
(yes should appear green, no should appear red)
I have made sure AutoCalculate is enabled.
Is it a known bug, or am I misunderstanding ...

**5**

votes

**3**answers

10k views

### Highlight a row where a value changes relative to previous row (Conditional Formatting?)

I have a spreadsheet with lots of data. The data is grouped so that all the rows with a certain value in one column (say C) are grouped together. I want to highlight the "boundaries" - i.e., the first ...

**5**

votes

**4**answers

5k views

### Colour coding blocks of rows using conditional formatting

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore.
Using Excel ...

**5**

votes

**0**answers

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

**4**

votes

**3**answers

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

**4**

votes

**2**answers

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

**4**

votes

**2**answers

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

**1**answer

22 views

### Alternating color in visible rows based on column value in Excel

This is similar to Alternate grid background color in excel when a value of a single column changes? , and I believe it can be done using SUBTOTAL(109,... , but I can't quite figure it out.
The first ...

**4**

votes

**1**answer

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

**4**

votes

**1**answer

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

**4**

votes

**0**answers

188 views

### Conditional formatting for meetings outside normal working hours in Outlook

I'm trying to get meetings that start before 10:00 AM highlighted in red. I've tried to use the Conditional Formatting feature; in the advanced tab I selected the "Start" field and "on or before" ...

**3**

votes

**1**answer

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

**3**

votes

**1**answer

39k views

### Change the Fill Color of a cell if the value of that cell equals the value of another specific cell

I want to change the fill color of cell C5 if it has the same value as cell A5.
Can this be done? I know how to format cell C5 if it has a certain value - but not when it is to be compared to the ...

**3**

votes

**2**answers

10k views

### Excel - conditional formatting in Shapes?

For a long time, I didn't think it was possible to have a Shape (e.g., Text Box) have a value set by formula, but it turns out you can. Similarly, it appears that you can't apply conditional ...

**3**

votes

**2**answers

4k views

### How can I format data bars based on value in Excel 2010?

I have a dataset containing values from 0 to 584. I would like to illustrate this using data bars, but I would like the databars to be green when the number is greater than 150, and red when the ...

**3**

votes

**2**answers

8k views

### Excel: conditionally format a cell using the format of another, content-matching cell

I have an Excel spreadsheet where I’d like to be able to create a “key” of formatted cells with unique values, and then in another sheet format cells using the key formatting.
So for example, my key ...

**3**

votes

**2**answers

3k 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 enters)...

**3**

votes

**1**answer

78 views

### Formatting Entire Row with Multiple Rules

I would like to change the formatting (specifically text color) for an entire row based on which selection is chosen from a drop down list in Column C. Example:
If C2 equals 'XX'(one of the ...

**3**

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

**3**

votes

**1**answer

255 views

### How to color rows based on two cell values in Open/Libre Office?

I am trying to apply conditional formatting to an entire row based on two cell values. The style is to be applied only if both cells have a particular value. I tried applying formula of the form:
$A1=...

**3**

votes

**1**answer

5k views

### Transferring Conditional Formatting (without the cell value) in Excel

If I have 3 layers of conditional formatting in a cell (B2) is there a way of transferring the format of cell (B2) to another cell (A2) without copying across the value in the original cell (B2).
I.e....

**3**

votes

**1**answer

144 views

### Is it possible for Excel to check conditional formatting on key press?

I have defined a conditional formatting for a cell like equal to 'a' but it seems Excel checks conditional formatting after I select another cell (and un-focus the cell which has conditional ...

**3**

votes

**1**answer

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

**0**answers

54 views

### Highlight differences between two Excel spreadsheets

Data from Spreadsheet A has multiple columns but I need to compare only:
Column A - order #
Column C - count
Column D - date
Spreadsheet B also has many columns, but I need to compare:
Column A - ...

**3**

votes

**1**answer

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

**2**

votes

**3**answers

21k views

### How to hide number but keep Excel cell background color?

I got a sheet like the below figure. I want to hide all the number and just keep the background color. How can I do it?

**2**

votes

**4**answers

9k views

### Excel function determine if a cell is visible

In conditional formatting I want to detect if the row above the current cell is hidden or visible. How can I detect if a cell is visible or not?
The only hack I can think of is:
Create a column ...

**2**

votes

**2**answers

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

**2**

votes

**2**answers

5k views

### Conditional formatting issues in Excel

I seem to be having a problem with conditional formatting in Excel 2010. I have a set of date points, percentages between 1 and 100. I applied three rules in the following order,
if greater than 75%...

**2**

votes

**1**answer

253 views

### Format cell in Excel if contents are a number or a function

I understand conditional formatting but I don't see how it can help me. I'm looking at a sheet with many product entries and for most of them I get values from a table (vlookup) while for others I ...

**2**

votes

**2**answers

171 views

### Conditional formatting on the first x number of rows, regardless of filter or sort, in Excel

I'm trying to find a way to easily identify the first ten rows in a table column, no matter how it's been sorted/filtered. Is there a way to use conditional formatting to highlight these cells?
...

**2**

votes

**2**answers

91 views

### How to do a conditional formatting in a table from a graph?

As you can see in this example below, I would like to be able to put in red the negative numbers that are in the table below the graph. I would like to apply a conditional formatting on this table (...

**2**

votes

**3**answers

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

**2**

votes

**4**answers

630 views

### Is it possible to have a conditional formatting cell “visually cycle” through all the formats that evaluated true?

Like the title says, "In Excel, when a cell has multiple conditional formatting rules that evaluate true, is it possible to have the cell "visually cycle" through all the formats that evaluated true? ...