**2**

votes

**1**answer

50 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

33 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

278 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

29 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

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

**1**

vote

**1**answer

23 views

### Why does Excel automatically apply conditional formatting to other cells?

I construct following table in Excel 365:
I select the entire column D and add conditional formatting.
Whenever I fill out an additional row, the cell in column D is coloured and the other ones ...

**1**

vote

**1**answer

22 views

### Selective conditional formatting when midnight is time in the cell

I have created a sheet where the first column is an hourly timeline starting with a user entered time and date. The user inputs the time and date in cell F4. Subsequently the timeline starts in cell ...

**1**

vote

**1**answer

30 views

### How to get Excel conditional formating to recognize boolean operations

I have constructed a spreadsheet to color code incoming scientific data based on different levels of criteria.
My problem is with data coming in as 'less than'.
For example, if the data shows ...

**1**

vote

**1**answer

225 views

### Align rows from different columns (which contain some cells that have identical values) using simple formula in Excel

I have 2 tables in Excel and I am trying (via Excel formula) to match/align some rows (ones that contain identical letters for the sake of the example included below). Btw, I don't mind aligning Table ...

**1**

vote

**1**answer

499 views

### Excel VBA - Conditionally format a cell using 2-color scale based on 2 values (max/min) on other cells

I'm trying to write VBA codes to conditionally format (2-color scale) cell A1 based on its value that between is >= cell A2 and <= cell A3. I'm using cells A2 and A3 so I can change the specific ...

**1**

vote

**1**answer

295 views

### How to use Conditional Formatting to change text color to match conditional fill color

I have used the Conditional Formatting to change the Cell fill color based on the percentage number. However, I would like to hide the text so I just have a bunch of colored squares with no value ...

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

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

171 views

### Outlook conditional formatting for meetings outside normal working hours

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

**1**

vote

**0**answers

19 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

53 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

99 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

59 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

33 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

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

**1**

vote

**0**answers

230 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

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

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

333 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

### Excel conditional formatting, greater than a year

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

20 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

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

**0**

votes

**0**answers

35 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

21 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

38 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

18 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

10 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

47 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

7 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

32 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

18 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

57 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

22 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

27 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

43 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

132 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

44 views

### Conditionally change colors of events in calendar on mac?

Is it possible to conditionally change colors of particular events in calendar for mac ? the same way week cal on iOS works? Maybe with applescript?
I havent found any apps for mac that can do that.
...

**0**

votes

**0**answers

39 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

32 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

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

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

**0**

votes

**0**answers

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