**-2**

votes

**0**answers

50 views

### Compare and group rows based on the sequence of their cell values in Excel 2013

I have one worksheet written to show packing contents for different products. This is how it is set up; Column A includes model numbers. Photos and part numbers are included in columns B through AH. ...

**0**

votes

**0**answers

11 views

### Outlook conditional formatting doesn't match text in links

I'm trying to highlight mails that contain my name inside the message. If I perform a search with about:Fabian everything works as expected and Outlook finds all mails.
However if I set up a ...

**1**

vote

**1**answer

22 views

### Excel: Compare multiple columns to see if less than value in another column for all rows

I am trying to compare data across multiple columns to see if each cell is less than a value in a single cell on the same row.
Column B contains the mean across all employees for the variable in ...

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

**0**

votes

**1**answer

29 views

### Excel 2013 conditional formatting

I have data in multiple cells in a row. I want to highlight cells A to K based on cell L value (text from a list). Further to this if I place any text to cells M or N or P then all the highlights must ...

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

**1**

vote

**1**answer

28 views

### Conditional formatting if an input cell is blank in a row marked completed

I want to highlight any blank input cell in a row if the row is labeled as completed in column B. There are several columns with information being entered in them and I would like to use this as a ...

**0**

votes

**1**answer

26 views

### Excel custom function | formatting

I'd like to get the SUM of cells with a specific format in the same format.
For example, I have a column of column of cells with:
23/02/11
00/01/02
05/12/06
28/15/19 < I want the total to be ...

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

**0**

votes

**0**answers

21 views

### getting a cell to reference itself (need it for conditional formatting)

My spreadsheet involves highlighting cells that have values that are also found in a separate range.
When using a formula to apply a rule in excel im not sure if the syntax is the same. It says: "...

**-1**

votes

**2**answers

68 views

### Excel 2013 - combine conditional formatting

Excel 2013, Windows 7 Pro.
I have a spreadsheet with some Conditional formatting, but I need multiple rules & I don't know how to make them work correctly together.
1) First, I want one specific ...

**0**

votes

**1**answer

34 views

### Applying conditional formatting using the average of each individual row

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 color cells based on their proximity to the average value, I want ...

**-2**

votes

**0**answers

10 views

### Google Sheets Format based on time of day and 2nd condition [migrated]

I have a sign-in sheet where attendees sign-in for their cases. I want to write conditional formatting for the cell to turn red if they have not signed in by 8:45am on the current date - so two ...

**1**

vote

**2**answers

57 views

### Changing cell colors in Excel based on data in another worksheet

I have a storage facility where I am trying to use Excel
to track all the units. I understand conditional formatting well enough
to change the text and cell colors for the unit size and current status ...

**0**

votes

**0**answers

71 views

### Excel - How can I use a Start and End date to format cells

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

**3**answers

62 views

### Excel 2013 - combining conditional formatting

I'm not very proficient when it comes to Excel formulas, so a few weeks ago I posted a question & got a great answer. Since then, I realized there's one additional thing that would make this even ...

**0**

votes

**1**answer

29 views

### How do I insert thousands-separators without affecting significant figures in Excel?

I need to figure out how to add thousands separators to large spreadsheets without affecting the amount of significant figures or the dates that are also in the tables. I can't figure out how to use ...

**0**

votes

**1**answer

35 views

### Microsoft Excel TIME related Conditional Formatting

I'm maintaining an attendance table in the following format.
01 Wed IN | 01 Wed OUT
==========|===========
08:27 | 17:16
08:36 | 14:31
08:38 | 17:07
08:32 | 17:05
08:47 | 17:05
...

**0**

votes

**0**answers

15 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

20 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

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

**1**

vote

**1**answer

25 views

### Cannot use Conditional Formatting in Workbook

The problem is simple enough to state. When I select a range of cells (as numeric values or indeed as values calculated from a formula), I cannot conditionally format them. What I want to do is to ...

**3**

votes

**0**answers

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

**0**

votes

**1**answer

40 views

### Excel 2010 Conditional Formatting Cell color based on a group of text cells

Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has text values 'Yes', 'No', 'In Progress' I want to ...

**0**

votes

**0**answers

10 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

**1**answer

2k views

### If Function is not working in Excel

I had made a sheet to calculate factory workers timing and payment against working and over time.
First I made it in Excel 2013 and then I changed my Windows from 10 to 7 and also changed the ...

**1**

vote

**3**answers

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

**0**answers

24 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

**2**answers

40 views

### Apply Custom Number Formatting to Error values

I'm trying to apply a custom number format to cells in Excel 2007 that return an error value.
I understand that I can apply custom number formatting to number/text values in the form POSITIVE;...

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

**2**

votes

**2**answers

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

**0**

votes

**0**answers

40 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

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

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

**0**

votes

**0**answers

28 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

**1**answer

68 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

27 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

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

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

**1**

vote

**1**answer

656 views

### Recolour a single occurrence of a recurring appointment in Outlook 2010

Brief: Recolour a single occurrence of a recurring appointment.
I have the following recurring appointment:
Subject: Maths 104
Date: N/A (series)
Time: Thursday 12pm
Recurring: Weekly (4th March to ...

**0**

votes

**1**answer

86 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

**1**answer

20 views

### Excel: conditional formatting with with complex function AND

I have a sheet that looks like this:
So I have a list of documents to create, and I mark "1" on the column with the month in which I have created them.
Now I've been asked to put "1" also as a ...

**1**

vote

**3**answers

48 views

### Conditionally format entire row based on a cell value [duplicate]

I know this has been asked before, but I must be missing something. I want to put a border above all rows that contain "Monday".
The formula is =$B$3="*Monday*"
I thought it might be because ...

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

**1**

vote

**1**answer

54 views

### How to highlight 2017 in Excel

I need cells in Excel to be highlighted if they contain 2017 in the date. For instance there is a column that has just dates. Some dates are for 2017. I need to input those dates at a later time.
The ...

**1**

vote

**0**answers

22 views

### Prevent Excel 2016 from changing Conditional Formatting ranges & “Apply To” ranges [duplicate]

There must be an easier way to deal with this.
| A | B |
|-------|----------|
| Email | today |
| Email | tomorrow |
Here is the volatile method of conditionally selecting any row ...

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

**0**

votes

**1**answer

29 views

### Excel - Format cell showing always the first digit

So my question is simple, but I have trouble solving it. I want the cell to show always the first digit, no matter how long the number is - for example if I type 0123 - it displays 0123, and if ...

**0**

votes

**1**answer

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

**2**

votes

**1**answer

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