**0**

votes

**2**answers

30 views

### highlight birthday in a referenced cell

in Excel 2003
in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday
in cell A1 date of Birth
in cell B1 age with the formula:
=DATEDIF($A1,TODAY(),"Y") ...

**6**

votes

**11**answers

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

**2**answers

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

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

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

**1**answer

17 views

### Conditional formating of excel row based on the value of the first cell of the row

I want to apply a conditional formating for a row only if the first cell (A column) contains text starting with Volum. Is there a way to do such a thing ? Thanks in advance.

**2**

votes

**1**answer

23 views

### How can I use conditional formatting or a macro to italicize duplicates (but not the original) cells?

I have a spreadsheet in which there are many duplicates (intentionally), and I would like to highlight the duplicates but not the first instance of a cell. Below is an example row:
A A A A A B B B C ...

**0**

votes

**1**answer

42 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

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

**1**

vote

**1**answer

35 views

### Conditional formatting between 2 sheets

I've got a conditional formatting question I'm really hoping someone can help with. I've got a workbook with 3 sheets - "Total Data", "Pivot Table" and "Expired Data". Pivot Table is extrapolated ...

**1**

vote

**1**answer

39 views

### Multiple conditional color formatting on a cell using IF… IF… ELSE

I've got three columns of Names, gender, DoB. Gender column as either "M" or "F" keyed in. DoB column has the date of birth mentioned as dd-MMM
Color formatting of DoB column needs to fulfill the ...

**0**

votes

**3**answers

655 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

72 views

### How to do a conditional formatting in a table from a graph?

As you can see in this example below, I would like to be able to put in red the negative numbers that are in the table below the graph. I would like to apply a conditional formatting on this table ...

**1**

vote

**1**answer

35 views

### In excel 2010 how do I change the cell colour to red if the date entered is 2 weeks or more in the past? [duplicate]

I have a spread sheet and I want the colour of the cell to change to red when the date entered is two weeks (or more) ago as this will immediately show me when work is overdue so I can chase it up.
...

**10**

votes

**4**answers

13k views

### How do I keep Conditional Formatting formulas and ranges from automatically changing?

I've found that Conditional Formatting formulas and ranges will automatically adjust when you copy, delete, or move data around in a spreadsheet. While this is a nice idea, it tends to break things ...

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

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

**1**answer

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

**11**

votes

**3**answers

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

**1**

vote

**2**answers

18 views

### Fill a date-filled cell red if older than 30 days and no date paid entered in another cell

I have two cells in Excel that are for dates (date billed and date paid). I need the date billed cell (say A1) to fill red if it contains a date and that date is older than 30 days and nothing has ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

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

**2**

votes

**1**answer

3k views

### How to copy a column with conditional format by “value” - Libreoffice 4.1

I have a column that contains the data and a set of rules for the conditional format of the cells.
i.e. the conditional format changes the background colour of some cells if they are negative.
I ...

**0**

votes

**1**answer

53 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

**2**answers

37 views

### How to make a formula in one cell only run when another cell has a content

Hi I am using 2013 excel and have a formula in W269:
=product(u269,v269)+50
However I need this formula to run only when T269 contains a value (text not a number).
Here's some more details in case ...

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

**7**

votes

**2**answers

10k views

### How to conditionally create a hyperlink based on value of a cell

ColA Col B ColC
Project A A.pdf A.pdf
Project B No Link
I have a list of project records. One column (e.g., B) ...

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

**1**

vote

**1**answer

27 views

### Excel Conditional formatting if in list

I have a list of values J1:J100 and another list of values E1:E75
If a cell in column J matches a cell in column E, I would like this cell to be highlighted.
Any ideas what formula to enter into ...

**1**

vote

**4**answers

7k views

### Preserve conditional formatting on cut-paste

I have some data from different sources that I'm trying to line up to get a good handle on which fields they have in common and which they don't. To make it easier to see rows, I set up a conditional ...

**3**

votes

**1**answer

31k views

### Change the Fill Color of a cell if the value of that cell equals the value of another specific cell

I want to change the fill color of cell C5 if it has the same value as cell A5.
Can this be done? I know how to format cell C5 if it has a certain value - but not when it is to be compared to the ...

**0**

votes

**1**answer

16 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

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

**1**answer

26 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

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

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

**1**answer

29 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

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

**0**

votes

**1**answer

52 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

172 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

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

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

**8**

votes

**3**answers

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

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

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

**0**

votes

**1**answer

55 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

30 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

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