**2**

votes

**1**answer

65 views

### Highlight rows that don't match other sheet

I'm not sure if this is possible, but I have two spreadsheets that I need to compare in a few different ways.
Here is the scenario:
**Sheet 1**
Column O=Claim Number;
Column P=Reserve Indemnity; ...

**2**

votes

**1**answer

37 views

### Excell 2007 conditional formatting

I have created an excel spreadsheet where in each cell there is a formula which gives a value with two decimals. I need to use the conditional formatting to highlight the cells in which the second ...

**2**

votes

**1**answer

360 views

### How to apply conditional formatting only to cells that contain a subtotal formula

I have a list of values, I have to alternate color of each row (that works fine).
In that list I also have subtotals, calculated using the SUBTOTAL function.
How would I be able to give just the ...

**2**

votes

**1**answer

31 views

### How to show a value of a Cell as it's displayed

I have a cell A2 that shows the value 001. I want to concatenate that value of 001 to a string to show REQ-001. The cell that I want to show this string I have =CONCATENATE("REQ-",A3). But the ...

**2**

votes

**1**answer

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

**2**

votes

**1**answer

172 views

### Excel conditional formatting when part of validation list

I'm trying to use conditional formatting on a cell that is populated via a validation list. It will not format. I try the exact same formatting on another cell which is not populated from a drop ...

**4**

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

**0**answers

187 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

**0**answers

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

**1**

vote

**0**answers

41 views

### Is it possible to use conditional formatting in Word 365?

Is it possible to use conditional formatting in Word 365, as it is possible to do in Excel 365?
I know that you can add an Excel sheet inside a Windows document, and use conditional formatting inside ...

**1**

vote

**0**answers

54 views

### How do I use an IF-THEN or Condition Statement for Excel 2013?

What would the condition statement be if I wanted all my sold items to go red in column F, but leave the ones un-shaded that have the word "Received" also in column F? The Headings of my Excel sheet ...

**1**

vote

**0**answers

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

**1**

vote

**0**answers

62 views

### Formatting of entire column based on the grand total using color scale?

This might be answered somewhere else, but I haven't been able to find a solution to this. The question is how to use color scale for entire column just based on grand total.
I have attached the ...

**1**

vote

**0**answers

34 views

### Excel for Mac 2011 - Conditional Format - Look inside formula for sheet reference

I would like to use conditional formatting to locate all cells on a large sheet (Sheet 1) that have a reference to another sheet (Sheet 2) within a formula in a cell on Sheet 1. I was hoping I could ...

**1**

vote

**0**answers

241 views

### Conditional Formatting a date/time comparison

The function I'm working on specifically compares & colors a daily recurring time range set in 2 different cells. A specific date in the target cells (produced by a formula) compare to that daily ...

**1**

vote

**0**answers

77 views

### Conditionally generate Excel sheet

I currently have an excel sheet that is used to record daily a bunch of parameters. Currently, I have a folder for each year, containing a folder for each month, inside of which I have an excel file ...

**1**

vote

**0**answers

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

**1**

vote

**0**answers

4k views

### Conditional formatting, greater than a year in Excel

I am working on a spreadsheet that logs the dates parts were sent out and would like to apply conditional formatting to the dates.
I would like if over 3 years ago, if over 2 years ago, if over 1, ...

**0**

votes

**0**answers

14 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

39 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

**0**answers

16 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

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

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

74 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

**0**answers

36 views

### Excel Conditional Formatting disappears unless smaller dataset in filter

Conditional Formatting on a Power Pivot (Excel 2016 32-bit) using a Color bar is working nicely when results are page filtered to a smaller subset. But when nothing is filtered, the CF disappears, so ...

**0**

votes

**0**answers

30 views

### Conditional formatting from a clock on Excel 2010

I was wondering if anyone can help me with my spreadsheet.
I have set up a macro in cell L1 to run a clock the programming is as follows:
Dim running As Boolean
Sub clock()
running = Not (running)...

**0**

votes

**0**answers

52 views

### Conditional formatting to highlight differences between 2 pivot tables in Excel

I have an Excel issue I hope somebody may be able to help me with please?
I have 2 pivot tables that both contain the following fields:
'Provider ID' in the Rows area,
'Month' in the Columns area ...

**0**

votes

**0**answers

27 views

### EXCEL: How can I use a custom function created in VB as formula for conditional formatting?

I created a VB script to validate a personal document from my country (just like the Social Security number in USA).
It is BOOLEAN, receives the number as param and returns only TRUE or FALSE if it's ...

**0**

votes

**0**answers

122 views

### Conditional formatting of pivot table cells based on value of a separate field

I have a pivot table which has, for the purpose of this question, "document-ID" as a row label, "person" as a column label and "date signed" as value field. Is it possible to give each cell containing ...

**0**

votes

**0**answers

20 views

### Condtional formatting

I have a question on how do you write a formula in a conditional formating if it sees the text funded in colume h I want to highlight column a the loan number when it sees the world funded only for ...

**0**

votes

**0**answers

25 views

### data bars conditional formatting in Excel

I need to format cells in a column with data bars of two different colors, depending on cell values in previous column. For example: if the value in the cell on the left is greater than zero, then ...

**0**

votes

**0**answers

111 views

### Conditional format a single letter without other cells containing the same letter

I need to conditional format my spreadsheet so that all the Nos ( N ) and all the Yes' ( Y ) are formatted without other cells containing the letter n or y also being highlighted.
I would like to ...

**0**

votes

**0**answers

11 views

### Conditional formatting icon sets of one row applied to other rows, icon sets

I have a question on how to apply conditional formatting icon sets of one row to other rows without using format painter? The issue is that I have over 100k rows.
For example, the data is compared ...

**0**

votes

**0**answers

38 views

### Outlook Query to highlight messages that mention me?

In essence, I want to do some conditional formatting on messages that mention me. Below are 3 sample Messages (Bodies). The first two should be purple, the last one should not be purple because I ...

**0**

votes

**0**answers

19 views

### Microsoft Excel 2013 - Auto-generating a page with parent formating

I have a multi-line activity log which is created using merged cells and colored borders, and often times the activity log follows on to a new, un-formatted page.
Is there a way to have excel create ...

**0**

votes

**0**answers

83 views

### Excel 2007 Conditional Formatting On Formula Not Updating When Cell Updates

I have set the following conditional formatting rules:
=$B97=1 Set Format (Custom) ">" @ On cell =$D97
=$B97=2 Set Format (Custom) "> >" @ On cell =$D97
=$B97=3 ...

**0**

votes

**0**answers

25 views

### Conditional formatting in Excel 2010 - Highlight a whole row in which a cell value falls between a specific day range

I need the whole row highlighted in yellow if the value entered in a cell (in Column C) falls between the 6th and 19th of any month or year, or in blue if it's between the 20th and the 5th.
Thank you ...

**0**

votes

**0**answers

34 views

### Excel - Conditional formatting retention through data validation in another sheet

I have applied conditional formatting in an Excel sheet (Sheet2) to change the font color in column A if the result in the adjacent cell in column B is "No." I then used this conditionally formatted ...

**0**

votes

**0**answers

52 views

### How do I apply conditional formatting to many workbooks?

I have 120 similar excel workbooks. They each have one sheet containing a small customer databases.
I want to apply conditional formatting to all these workbooks. I can do it in one workbook. Is ...

**0**

votes

**0**answers

159 views

### Excel: Conditional formatting for column merge

I'm looking to create a timetable that is formed by combining material from several worksheets. It does not seem to be possible to automatically consolidate text from several worksheets, but it is, of ...

**0**

votes

**0**answers

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

**0**

votes

**0**answers

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

**0**

votes

**0**answers

364 views

### Update conditional formatting cell references when conditional formatting is applied to new cell

I am applying conditional formatting to cells on my spreadsheet, using the following formula in cell C6:
=INDEX('All Time'!$F$2:$F$550,MATCH(INDEX('All Time'!**$A$7**:$A$550,MATCH("*",'All Time'!$A$7:...

**0**

votes

**0**answers

2k views

### How to use a color coded drop down in Excel across multiple sheets?

I have seen a few examples on how to create a color coded drop down in an excel spreadsheet.
An example of what to do can be seen here. http://stackoverflow.com/questions/12643522/excel-2007-drop-...

**0**

votes

**0**answers

40 views

### How to use Color Bar for String Values in Excel 2010

I like to color the backgrounds of the cells which has similar values. There are huge no. of such values so it is not possible to create condition/rule for each. I am looking for a shortcut. Like this ...