**0**

votes

**1**answer

48 views

### Excel formula to show differences in columns

In Excel, I want to highlight the difference between 2 columns so that I can see if the person's money has increased or decreased by more than £500 since last month.
I don't want to add a 3rd column ...

**0**

votes

**1**answer

60 views

### How to change cell function [not data] through drop down list

For my very first post I may have a slightly complex question. I've had a decent look around, and either excel doesn't have the functionality or I've got my terms mixed up.
I want to create a ...

**0**

votes

**1**answer

20 views

### Excel nested IFs

I'm trying to combine several IF formulas with an IF(AND formula but struggling. I can manage Nested Ifs or an IF(AND formula but can't seem to combine them.
I want to say if L2 equals 1,3 or 4 then ...

**0**

votes

**1**answer

2k views

### Conditional formatting of PowerPoint-table

Related to this question, I wonder if there is any way to apply conditional formatting to a table in PowerPoint, without importing an Excel-table. E.g. to change the background colour of a cell in the ...

**0**

votes

**1**answer

19 views

### Duplicate and Unique formatting in same column?

Is it possible to apply both a duplicate and a unique format to a column?
I know that a value can only be one, but what if I'm applying the unique rule to say, Col 1 and Col 2 (checking for values ...

**0**

votes

**1**answer

163 views

### Conditional formatting on blank cells in non-blank rows

I'm looking for how to apply conditional formatting to blank cells - but ONLY if the row they are in is not completely blank.
For example, I'm making a project tracking sheet, and I want incomplete ...

**0**

votes

**1**answer

55 views

### Excel formula related to conditional formatting

Column A has 10 numbers expressed as percentages and is conditionally formatted to highlight the top 40%.
I want column B to show a "1" next to the corresponding highlighted top 40% of numbers in ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

73 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

**1**answer

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

**0**

votes

**1**answer

1k 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
[Green]+0.00%;[Red]-0....

**0**

votes

**1**answer

25 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

31 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

201 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

**2**answers

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

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

**0**

votes

**1**answer

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

**1**answer

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

**1**answer

86 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

124 views

### Conditional formatting duplicates for highlighted cells

I would like to conditionally highlight cells in a row. When the items in column B are duplicates then cells in columns B and C should be highlighted.
The value 7264 in column B has duplicates so ...

**0**

votes

**1**answer

277 views

### Account based Conditional Formatting

I have two accounts in Outlook 2013, my work Exchange account and my personal Hotmail account. I am trying to conditionally format the tasks and emails in my To-Do List based on which account they ...

**0**

votes

**2**answers

1k views

### Conditional format cells that are duplicated in every column

I have a table in which every column describes a product and every row is responsible for one attribute of the product. I want to highlight cells which are duplicated in every column.
I have for ...

**0**

votes

**1**answer

327 views

### How do you use conditional formatting in Excel to format based on previous cell information?

I have a document that is created to monitor complaince. I would like to have the following rules:
Highlight the cell if it meets a goal - I've figured this out and the formatting works.
Highlight ...

**0**

votes

**1**answer

4k views

### Why am I getting unexplained vertical lines in the center of merged cells?

I am working on a spreadsheet that merges 20 columns into a single row. This row is conditionally formatted to display a data bar, of a proportional length based on a set of values from 0 to 275 that ...

**0**

votes

**1**answer

6k views

### How to let Excel 2007 display a certain text as long/soon as a cell is empty? [duplicate]

Possible Duplicate:
custom format for cells with nothing in them without using conditional formatting
I'd like Excel 2007 to display a certain text like "" as long as a cell is empty.
So if ...

**0**

votes

**2**answers

4k views

### How can I set up conditional formatting to highlight a range only if all its cells are empty?

I am new to conditional formatting and having a hard time. I have 6 columns with 100 rows. What I would like to have happen is to highlight the row in one color if there is no data in it at all. If ...

**0**

votes

**2**answers

4k views

### Conditional formatting 2 different colors every two rows

I want to apply conditional formatting to change the background color of alternating rows on a spread sheet. The rows will alternate between two colors (yellow and green) two lines each.
This is the ...

**0**

votes

**3**answers

426 views

### CF: Cell STATUS + Cell DATE compared to NOW(DATE) = Colour

If the status in cell $D5 is "AWAITING FEEDBACK" I want to compare the DATE in cell $H5 against TODAYS DATE and CONDITIONAL FORMAT cell $H5 using the data bars formatting (colour to transparent).
If ...

**0**

votes

**0**answers

11 views

### Excel Automatically Fill Cells In Time Range

I am trying to create a calendar that will fill cells in the graph to reflect the times listed out in Columns D and F.
In essence, my hope is that I can enter the start time, enter the end time, and ...

**0**

votes

**0**answers

12 views

### Excel - Can I use a date range to format a cell

I have a calendar and a table of events on a worksheet. The table of events include a Start and End date as well as Status columns. I would like to highlight the dates on the calendar where the ...

**0**

votes

**0**answers

15 views

### Extend 3-color conditional formatting from one column to adjacent column

I want to format my cells in a way where the colors are displayed according the the color-rule as in column 1, but the values that you see within the colored area are the ones of column 2.
Column 1 ...

**0**

votes

**1**answer

26 views

### Applying conditional formatting to individual rows

I'm trying to apply conditional formatting to a few hundred rows of data, but I want to keep them separate. Meaning, if I want to coloring cells based on their proximity to the average value, I want ...

**0**

votes

**1**answer

30 views

### Conditional formatting in Excel combining 2 rules?

I want to format my dataset (22x12 values) with the 3 color rule, but based on the values of another dataset so that the color can be used as additional information.
Here my example. I want to ...

**0**

votes

**0**answers

8 views

### Is there an easy way to manage a large number of conditional formatting rules?

Using Excel 2010, I've created a very large number of conditional formatting rules. You can see how small the thumb is - there are a lot of them.
Unfortunately, the conditional rules manager dialog ...

**0**

votes

**0**answers

21 views

### Getting Excel to Conditionally Copy Data to Another Sheet

I have a spread sheet that will have new data entries on each row. I need to get excel to automatically check for a specific column's value, and if that value is a 1, it needs to go to the sheet with ...

**0**

votes

**0**answers

37 views

### White space between columns in Excel

There are white spaces between columns in excel when I have conditionally formatted them to shade depending on row. How can I fix this?

**0**

votes

**0**answers

22 views

### Conditional formatting of “difference lines” in a 2 series chart

I have 4 columns of data:
1st column is the name of the Route
2nd column is Time1 in decimal hours
3rd column is Time2 in decimal hours
4th column is TimeDifference in decimal hours (or decimal ...

**0**

votes

**1**answer

55 views

### Formula or VBA for cell formatting using value based on a cell but formatting from an other cell

I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E.
If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell.
For example,
...

**0**

votes

**2**answers

24 views

### Custom formula for databars in Excel

How would one go about using a custom formula to determine the format conditions for databars?
Meaning, in Excel under "Conditional Formatting" there's a format called "Data Bars". However, you ...

**0**

votes

**2**answers

2k views

### How to Change Conditional Formatting of a Cell Based on a Change in the Cell Value

I am desperately looking for a way that allows me to conditionally format a cell depending on whether its value has increased, decreased or stayed the same.
However, I don't want to compare its ...

**0**

votes

**1**answer

20 views

### How do I represent 1 + “” in conditional formatting?

I have a formula that spits out 1 and "" in the same cell. (its an &) anyway it stopped the conditional formatting from recognizing the cell's value as 1. What value can I use to make the ...

**0**

votes

**1**answer

58 views

### Outlook: Shared Calendar conditional formatting

Situation: My work group has a shared conference call dial-in number. To avoid double booking the dial-in number, we have to reserve time in a shared calendar. All users have read/write permissions, ...

**0**

votes

**0**answers

25 views

### Extracting a Sublist from Master List

How do I write a formula to find the exact matched of the subsets and extract it from the master?
Basically what I have is a master data spreadsheet of 275,000 rows of data. I then have a queried ...

**0**

votes

**0**answers

33 views

### Excel 2010 Conditional Formatting issue

I'm experiencing a problem with conditional formatting in Excel 2010. I want any value other than 1 to be shown in red.
I am working with multiple tabs, with one main tab. The entries in the other ...

**0**

votes

**0**answers

27 views

### Using Excel to flag non contiguous data

I need a way to flag gaps in a list of numerical data. Like using conditional formatting to flag a series like 1,2,3,5,6,7. The cells containing 3 and 5 would be highlighted showing a gap.

**0**

votes

**0**answers

24 views

### Change text color and underline output of Excel [duplicate]

I'm wanting to do something I thought to be simple but can't seem to get it working.
I want an IF statement that, once evaluated, the result output is underlined and changed to a color (e.g., red).
...

**0**

votes

**1**answer

53 views

### How to format entire row when any cell of the row contains any value?

I want when there is any value (whether any alphabetic or numeric value) in any of the cell into the row from a1 to p1 then the entire row (from a1 to p1) should be formatted.
For example there is ...

**0**

votes

**1**answer

40 views

### Format entire row in Excel Table if row is empty

I have a Table (as opposed to a Range) defined in Excel 2010, named Table1.
The table has blank rows separating groups of 3 to 5 rows with data. Note that not every column in every "non-blank" row ...

**0**

votes

**0**answers

73 views

### Conditionally apply formatting (table style options) to word-table last row

In word 2016 I have a document template with a predefined table-style.
When I apply this table style I can choose to e.g. apply 'total row' formatting.
I would like to apply total row formatting via ...

**0**

votes

**1**answer

205 views

### Displaying data in Excel graph only up to current date?

I have an Excel chart that displays 5 sets of data in a single scatter plot, where the X axis is the date of occurrence. In my table, I have both actual values from previous dates and projected values ...