**1**

vote

**2**answers

102 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

33 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

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

**12**

votes

**3**answers

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

18 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

25 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

20 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

429 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

20 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

598 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

29 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

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

**0**

votes

**3**answers

27 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

29 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

51 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

20 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

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

27 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

44 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

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

**0**

votes

**0**answers

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

**3**

votes

**1**answer

3k views

### Excel conditional formatting to highlight entire row if one date is not equal to another date in that row

I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...

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

**1**answer

111 views

### Displaying data in Excel graph only up to current date?

I have an Excel chart that displays 5 sets of data in a single scatter plot, where the X axis is the date of occurrence. In my table, I have both actual values from previous dates and projected values ...

**1**

vote

**1**answer

94 views

### Color-based text in Excel cell

Looked through available options, but failed to find the one in a format I would understand steps.
Working with Excel. Need to have cell changing color based on specific wordS (not one). For example ...

**0**

votes

**1**answer

417 views

### How to use conditional formatting to highlight specific days of the week AND time periods?

This answer regarding formatting on date time information Excel 2010 Conditional Formatting - TIME is a very, very technical answer that, in truth, I don't really understand! Hey-ho, I can deal with ...

**1**

vote

**1**answer

36 views

### Excel rearrange column using copy + paste

I am trying to create a method to automatically rearrange the column when performing copy + paste.
Say I have an excel file with table containing columns on the first row:
ID | NAME | DATE | ...

**0**

votes

**0**answers

24 views

### Change text color and underline output of Excel [duplicate]

I'm wanting to do something I thought to be simple but can't seem to get it working.
I want an IF statement that, once evaluated, the result output is underlined and changed to a color (e.g., red).
...

**4**

votes

**0**answers

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

**0**

votes

**1**answer

294 views

### How do you use conditional formatting in Excel to format based on previous cell information?

I have a document that is created to monitor complaince. I would like to have the following rules:
Highlight the cell if it meets a goal - I've figured this out and the formatting works.
Highlight ...

**0**

votes

**1**answer

44 views

### How to format entire row when any cell of the row contains any value?

I want when there is any value (whether any alphabetic or numeric value) in any of the cell into the row from a1 to p1 then the entire row (from a1 to p1) should be formatted.
For example there is ...

**0**

votes

**3**answers

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

**0**

votes

**1**answer

35 views

### Format entire row in Excel Table if row is empty

I have a Table (as opposed to a Range) defined in Excel 2010, named Table1.
The table has blank rows separating groups of 3 to 5 rows with data. Note that not every column in every "non-blank" row ...

**0**

votes

**0**answers

48 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

**3**answers

595 views

### Insert spaces in excel number sequences

I am trying to format cells so when I type in phone numbers it automatically formats them as follows: -
Landline Nos e.g. 02012345678 to appear as 020 1234 5678
Mobile Nos e.g. 07123456789 to appear ...

**6**

votes

**11**answers

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

186 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

39 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

34 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

32 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

31 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

55 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

31 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

43 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

54 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

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

80 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

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

**11**

votes

**4**answers

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

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