**0**

votes

**1**answer

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

**6**

votes

**11**answers

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

**0**answers

17 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

**1**answer

19 views

### Excel Conditional Formatting for Date colums

I have 2 columns with dates and I want to apply conditional formatting to all values where the date in one column is bigger than the date in the other column.
So, when the dates in "Actual End ...

**1**

vote

**1**answer

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

**0**

votes

**0**answers

16 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

**1**answer

23 views

### Define conditional formatting formula in Exel outside of conditional formatting formula bar

It is possible to use a formula to determine which cells to format. I don't think the formula bar of the CF menu is very user friendly for editing formulae.
My current solution is to write / edit ...

**-1**

votes

**1**answer

39 views

### How to compare values and apply formatting when one cell is a formula?

I need to apply conditional formatting in one cell based on its comparison against another cell that is of a different format. For example; Column A contains cells with formula. Column B contains ...

**10**

votes

**3**answers

56k 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 the cells having a distinct value a unique color without manually creating a conditional ...

**0**

votes

**1**answer

22 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

**2**answers

82 views

### How do I highlight the max values across every column in a pivot table?

Looking for a way to use conditional formatting to highlight the max value in every column of a pivot table.

**0**

votes

**0**answers

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

**5**

votes

**2**answers

1k views

### Excel conditional formatting fragmentation

Often, I create a sheet with conditional formatting, and set the cell ranges so that the conditional formatting rules are only applied once to a range of cells, e.g.
Make $A$1:$A$30 red and
Make ...

**7**

votes

**3**answers

30k views

### Microsoft Word 2010 - Conditional Formatting

Is there a way to apply conditional formatting to a table in Microsoft Word 2010, in much the same way that it is possible in Microsoft Excel?
Thanks.

**1**

vote

**1**answer

5k views

### customize excel 2010 highlight track changes

Is there any way to customize how Excel highlights cells on Track Changes? My customer requested us to "highlight anything you've changed by changing text color to red," and I'd like to implement ...

**0**

votes

**0**answers

23 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

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

**2**

votes

**1**answer

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

**0**

votes

**1**answer

42 views

### How to use conditional formatting to search a specific value in a range in ms excel?

I have values in the range K5:K333. I want the value in cell S5 be searched in the range and the corresponding cells of the range being formatted.
I am using conditional formatting's "use a formula ...

**0**

votes

**1**answer

25 views

### Prevent Outlook calendar conditional formating happening on iCal feed

I've got two calendars in Outlook 2010:
My own calendar (which comes from the company exchange server)
My personal calendar (which comes from Google in the form of an iCal feed)
If I apply ...

**0**

votes

**0**answers

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

**5**

votes

**5**answers

16k views

### Conditionally format a cell if it contains formula

Is it possible to conditionally format a cell if the cell contains formula (to alert myself and other users when updating the cell)?

**0**

votes

**1**answer

27 views

### Highlight row if ID is found on other sheet

I have one Excel file that contains 2 worksheets.
Worksheet 1 columns:
computernames Username E-Mail
comp1 username mail@mail.de
comp2 username2 mail2@mail.de
Worksheet 2 columns:
...

**0**

votes

**0**answers

41 views

### Outlook “conditional formatting” for meetings without other attendees

I'm trying to get meetings with other attendees (other than myself) to show up in a special color. My "own" meetings (without other attendees) are mostly just reminders, which I can easily move, but ...

**1**

vote

**1**answer

61 views

### Highlight Cells with Red Text

I have a column of text in which some characters (not cells) are in red font. Is there any way to highlight the cells which contain red characters via conditional formatting? VBA solutions would be ...

**0**

votes

**0**answers

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

**2**

votes

**2**answers

40 views

### Highlight duplicates only if the header is the same

I'm attempting to use Conditional Formatting to highlight a duplicate entry if and only if the Header to both columns are the same.
In my example below, this is a season long NFL contest of picking ...

**0**

votes

**3**answers

92 views

### Conditional formatting with multiple conditions

I have to set a simple formatting in excel: colour cells if the value is = to another cell.
The question is that I would like to colour the cells if the value equal to A1 or B1 or B3
Is it possible ...

**2**

votes

**2**answers

47 views

### Excel conditional formatting rows to highlight weeks in different colours

I am trying to automatically format the rows of my worksheet based on the date in the A column.
I am using the following to highlight the weekends.
=WEEKDAY($A6,2)<5
This works however I also ...

**5**

votes

**2**answers

35k views

### Excel Conditional Formatting if one column equal to another

This should be the simplest example of conditional formatting but I can't figure it out. I havave two columns seperated by several dozen other columns ('C'-original data, 'BO'- calculated value) and I ...

**1**

vote

**1**answer

33 views

### Copy Conditional Formatting 3-Color Scheme to another tab

I have one sheet, Tab 1, with a 38x12 grid of values ranging from -30 to +30. I applied the traditional 3-color scheme conditional formatting to the data, which shows all shades of the spectrum ...

**0**

votes

**1**answer

36 views

### How do I get the cells with no dates to have no color until the date is entered? All of the unused cells are red

=DATEDIF(F2,TODAY(),"m")<=47 THE CELL TURNS NO COLOR
=DATEDIF(F2,TODAY(),"m")>57 THE CELL TURNS RED
=DATEDIF(F2,TODAY(),"m")>54 THE CELL TURNS PINK WITH RED WRITING
...

**0**

votes

**2**answers

90 views

### In Mac Excel 2011, how to format cell as percentage or currency based on content of another cell?

As far as I can tell, the Conditional Formatting feature doesn't support percentages. You can format styles (color, font, etc.), but not the actual content presentation itself.
I have two columns, ...

**1**

vote

**2**answers

21k views

### Excel: Conditional formatting using icon sets?

I would like to format the Subtotal row such that within each Subtotal cell is the total and an "icon set" icon that will show if that month is greater than or less than the previous month's total.
...

**0**

votes

**1**answer

40 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

**0**answers

43 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

**2**answers

56 views

### IF statement with multiple criteria and multiple possible results

I have a spreadsheet and I need a formula to give me one of three possible results (good, neutral, bad) based on data from two cells. MTD and YTD on budget would be good, MTD on budget & YTD below ...

**3**

votes

**3**answers

28k views

### conditional formatting for subsequent rows or columns

I have data in a range of cells (say six columns and one hundred rows). The first four column contains data and the sixth column has a limiting value. For data in every row the limiting value is ...

**1**

vote

**1**answer

17 views

### Conditional Formatting in Excel via a different worksheet

I've been trying to figure out how to make a cell bold and color red based on conditions entirely in a different worksheet. For example, I'd like Sheet1!A1 to be bold and red when Sheet2!A1 = ...

**0**

votes

**2**answers

52 views

### Is it possible to have an Excel formula dependent on value input?

Is it possible to have Cell G24 recognize the number in D24, and do its math depending on the size of the number, using the in Cells B37 through B42?
I have a basic spreadsheet for cataloging sales ...

**5**

votes

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

**1**answer

74 views

### How do I superimpose a conditional formated heatmap based on one set of values over a different set of values in Excel 2013

I would like one cell to be formatted with a gradient color based on the value in another cell. For example, I would like cells A1 and A2 to be highlighted based on the values in B1 and B2. If I ...

**1**

vote

**1**answer

123 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

51 views

### Lock color scale (convert to fixed)

I have used conditional formatting to apply a color scale to a range of values. Now I would like to permanently freeze those colors. I have poked around a bit, and can't find event the beginning of ...

**6**

votes

**2**answers

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

**0**answers

19 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

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

**1**

vote

**1**answer

38 views

### Use Conditional Formatting on a Cell Based on matching a value in a range

I want to change the cell background of a cell (M16) if the number in it matches one of the numbers in a table of random numbers (M3:Q12)
Table of numbers - M3:Q12 Cell I want to format is M16.
...

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

**0**

votes

**2**answers

37 views

### Conditional formatting to mark rows depending on contents

I have an excel sheet that for the forseeable future will remain as a Work In Progress regarding a project. To easily be able to keep track of rows that need some work I would like to create a macro ...