**23**

votes

**9**answers

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

**1**

vote

**1**answer

24 views

### Alternate Row Colors of Duplicate Data in Excel

I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...

**2**

votes

**1**answer

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

**0**

votes

**1**answer

30 views

### In MS Excel how do I set the number of decimal places dynamically?

I have a table where I am reporting a range of correlation coefficients which range from -1.0 to +1.0. I want to format them such that if they are plus or minus one or zero, then they are formatted ...

**2**

votes

**2**answers

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

**0**

votes

**2**answers

21 views

### Insert spaces in excel number sequences

I am trying to format cells so when I type in phone numbers it automatically formats them as follows: -
Landline Nos e.g. 02012345678 to appear as 020 1234 5678
Mobile Nos e.g. 07123456789 to appear ...

**1**

vote

**1**answer

24 views

### How to highlight the first cell in a column that matches criteria with conditional formatting

In one column of a spreadsheet I want to highlight the first cell ONLY above a specific number. For example, if a column has values increasing from 0 in the first row to x in the last row, how do I ...

**0**

votes

**1**answer

18 views

### How to avoid apply to range in copying conditional formatting in excel 2007 [closed]

I want to change the selected cell(A1) colour if its value is greater than other cell(B1) in same row.When i copy this conditional formatting to other multiple cells(A2,A3,A4...) in below rows, it is ...

**0**

votes

**2**answers

2k views

### Excel INDIRECT function and conditional formatting - highlighting a row

I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...

**-1**

votes

**1**answer

12 views

### Conditional formatting (alternating between only two colours) of rows depending on cell values

How do i get conditional formatting done depending on values of cells.
I need to get the cells (and their rows) formatted in only two colours
Say,A1 has Colour1
if A2=A1, then A2 should get ...

**0**

votes

**1**answer

95 views

### Excel auto format cell's font size based on number value?

I want to make cell's number values to be smaller, in font size, with small values i.e. the bigger the cell value is, the bigger is the font size.
I can only find Data Bars in Conditional ...

**0**

votes

**3**answers

57 views

### how to get text instead of TRUE:FALSE in excel

suppose I have a formula in cell C3:=AND(A1=B1)
it will give TRUE:FALSE
but i need Yes:No instead
so how do I format the cell C3 to get so?
Thanks!
Regards,

**1**

vote

**0**answers

270 views

### Excel 2011 Conditional Formatting: compatibility issues

I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed).
The purpose is a semi-automatic calendar, where one enters ...

**0**

votes

**1**answer

15 views

### Apply conditional formatting to one cell based on part of a text in a cell

I have a spreadsheet containing a bank statement. In C I have a description of what the transaction is for sometimes just a word and other a sentence. In D I have money coming into the account and E I ...

**0**

votes

**1**answer

19 views

### How do I create a conditional format with 2 columns

I am trying to create a rule that would highlight a cell under these conditions:
Column B>1 & Column C=O
I want Column C to highlight if they meet these two conditions. Can someone help?

**0**

votes

**0**answers

25 views

### Formatting of dates in cell using Excel to show result as numbers

I am working with calculating the difference in years, months and days between 2 dates. My results are showing as eg. 32 years, 9 months, 3 days. How do I format the cell to show a result 32 9 3?
I ...

**1**

vote

**1**answer

28 views

### Alternative to cell highlighting using conditional formatting in Excel without causing freeze/crash

In column A, I have a value and I want to highlight if it doesn't match the same value in column B.
I'm using the formula below in conditional formatting which works great.
...

**0**

votes

**1**answer

24 views

### Conditional Formatting for Excel Greater than

I have applied a rule if the cell is greater than 50 fill with cell with RED. The cells are populated from another location. When I apply the rule the blank cells show up RED? Any help would be ...

**1**

vote

**1**answer

20 views

### Condition formatting dates two week before the actual target date

I have a spreadsheet in excel with a formula that when I enter a date into column A cells, column B cells will enter a date 9 months - 1 day from the date entered in cell A1, A2, A3, etc... Now I ...

**0**

votes

**1**answer

358 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

**3**answers

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

**4**

votes

**1**answer

484 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

**1**answer

24 views

### Format row that is different than the preceding VISIBLE row

I have an Excel sheet as a database, where each row has a category, and are always sorted by category.
Category Item
1 AAA jjj
2 AAA kkk
3 AAA lll
4 ...

**1**

vote

**4**answers

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

**0**

votes

**1**answer

29 views

### IF AND conditional formatting not working - Excel 2013

Okay so I’m trying to format cells that are blank and meet the logical test. Here’s the formula:
=IF(AND($B2="Y", ISBLANK($C$2:$F$172)), TRUE, FALSE)
If both tests are true (B column = Y and there ...

**1**

vote

**1**answer

25 views

### Get conditional formatting to analyze rows separately

I have a calendar and I am trying to fill the background of the cells based on dates on another sheet.
I have gotten it to work by entering the dates in a columns, naming the range (lets says ...

**0**

votes

**0**answers

11 views

### Conditional formatting based on text [duplicate]

Does anyone have a conditional formula/s that can compare text in two different cells?
I have a scale A-E and want to compare against another cell for eg: highlight a1 green if a1=A b1=D, but it also ...

**1**

vote

**1**answer

40 views

### Excel - if cell is empty AND if cell is empty - Colour Row

I'm a complete novice when it comes to conditional formatting. I've found a similar question that allowed me to change the colour of the cell, but not the row.
Here's a snipped of what my sheet will ...

**1**

vote

**1**answer

37 views

### Higlight a specific cell based on ADDRESS() return value

I want to give a style (highlight) a specific cell based on a date value. This date is, say, in cell
A1.
To achieve this, I thought I would calculate the address of the cell I want to style with the ...

**0**

votes

**1**answer

36 views

### Can I use conditional formatting to format a cell based on color in the cell itself and the cell before?

Conditional formatting Excel 2010 how to format a cell based on color in the cell itself and the cell before.
I have with Conditional formatting marked a start cell and end cell with red I want to ...

**5**

votes

**3**answers

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

**0**

votes

**0**answers

23 views

### Can I copy graduated scale conditional formats with relative references?

I have a number of columns, each populated with numbers. I want the color of the cells in each column to be conditionally formatted on a 3-color graduated scale, against the value in a single cell at ...

**0**

votes

**1**answer

50 views

### Excel conditional formatting for repeating values

I have a table of data where there are 50 rows and many columns. Each column's value is sorted by the most important result at the top. These are names of people in sports. I would like to see ...

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

77 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

39 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

76 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

79 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

145 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

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

**2**

votes

**1**answer

3k views

### How do I use conditional formatting in a spreadsheet based on dates?

I have a spreadsheet in OpenOffice V3.3.0 (used in Windows 7 32 bit). One column contains dates (in the format: 14 August 2011 ) and I want to use conditional formatting on those cells depending on ...

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

**2**answers

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

**0**

votes

**1**answer

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

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

**0**

votes

**1**answer

22 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?

**1**

vote

**2**answers

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

**0**

votes

**1**answer

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

**1**

vote

**0**answers

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

**3**

votes

**8**answers

31k views

### Prevents cells from printing in Excel

Is it possible to prevent the contents of specific cells (or entire row or column) from printing in Excel? I need to maintain the cell size. I've been setting the text color to white before printing, ...