**1**

vote

**1**answer

756 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.
=ISERROR(MATCH(A1,$B:$B,0)...

**1**

vote

**1**answer

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

**1**

vote

**1**answer

309 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

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

**1**

vote

**0**answers

137 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

**1**answer

793 views

### Is there anyway to format negative numbers in red in a table in Powerpoint 2010?

I have tables of data and I want the negative numbers to show up in red (similar to what you would do in Excel). Does powerpoint have this capability?

**1**

vote

**1**answer

162 views

### How to combine data from two sheets and conditionally format rows based on sheet of origin

I have 3 sheets in Excel "Open", "New", "Combine"
"Open" Sheet (Old list)
Ticket ID | Priority | Department | Status
36009 | 1 | Finance | 01-Open
34781 ...

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

**1**answer

261 views

### Excel 2013 - Problems splitting cell containing two decimal numbers

I need to separate values that look like this and are in one column in an excel spreadsheet.
48.116667, 11.55
I though this would be easy and did this: Select the column, click on (Data Ribbon) - ...

**1**

vote

**0**answers

66 views

### Excel 2011 conditional formatting, problems w/ adding deleting rows [duplicate]

I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row. The form varies wildly in length. Currently, I am using conditional ...

**1**

vote

**1**answer

665 views

### A formula to check if the date is older or equal to 60 days and another columns cell is equal to a value

I have tried using conditional formatting and managed to get the first part of the formula to work.
=D2:D999<=TODAY()-60
I want to then also check if the value of what is in column G is equal to ...

**1**

vote

**1**answer

51 views

### Conditional formatting excel conundrum

I have a list of values in excel.
I would like to highlight a cell if its more than 1.5 higher or lower than the value before it or after it.
Is this possible?
Thanks guys!!

**1**

vote

**1**answer

155 views

### Excel: Different background colors on condition

The problem
I have a Excel sheet that contains a status column.
Number Status Name
-------------------------------------
1 not implemented feature 1
2 completed ...

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

240 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

**1**answer

628 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

**1**answer

261 views

### Excel, Pasting text with hyperlinks, conditional formatting for doubles

I have a list of names that I paste, individually, from a site into a column of cells in a table. I have conditional formatting to tell me if there are doubles. However, when I copy straight from ...

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

**1**answer

3k views

### Excel 2007 - Conditional Formatting: Compare 3 columns with text - find unique values

I have a spreadsheet with three columns, each column listing the folder names found on a server.
Server1 | Server2 | Server3
--------|---------|---------
A | | A
--------|---------|----...

**1**

vote

**1**answer

1k views

### Excel 2007: finding duplicates ACROSS multiple columns [duplicate]

Possible Duplicate:
Excel 2010 conditional formatting: selectively highlighting duplicates
First of all, this is basically a cut-and-paste of another question regarding Excel 2010. When I ...

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

131 views

### How to apply conditional fomatting for a MAX value to a range of cells

I have a table that is five cells wide by twenty high with a sum function at the end (e.g. cel A20). I want to highlight the column that results in the highest SUM. How do I use conditional formatting ...

**0**

votes

**1**answer

29 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

**3**answers

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

**0**

votes

**2**answers

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

**0**

votes

**1**answer

1k views

### Conditional Formatting - Highlight An Entire Row by Comparing Two Cells of a Column

I've dug through the questions on this site and they address both problems I have, but separately. I've been trying to combine the solutions for a couple hours with no success.
Basically, I would ...

**0**

votes

**2**answers

28 views

### Apply Custom Number Formatting to Error values

I'm trying to apply a custom number format to cells in Excel 2007 that return an error value.
I understand that I can apply custom number formatting to number/text values in the form POSITIVE;...

**0**

votes

**2**answers

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

**0**

votes

**2**answers

2k views

### Excel 2010 Conditional Formatting for a range based on “Less Than” and “OR”

How do I use conditional formatting on a range of values such that every third cell should be filled with a particular color if the value entered in that cell is lower than values in any of the three ...

**0**

votes

**3**answers

345 views

### Excel: How to format each group of data separately

Is it possible to automatically color each row of data, so that the beginning and end of each day is more visible? Do you think I can do that with conditional formatting? Something like the following ...

**0**

votes

**2**answers

7k views

### Setting background colour of cells based on their string length

Suppose I have this column of data
Canada
Chile
China
...
How do I set the background colour of each cell if the length of the string in it is greater than say 5? ('Canada' cell would be ...

**0**

votes

**2**answers

3k views

### Excel INDIRECT function and conditional formatting - highlighting a row

I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

89 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

**3**answers

68 views

### Adding a date to a formula in excel [closed]

=$M2="COMPLETED"
I am using this formula to shade a row when COMPLETED is written in column M, but I would prefer the 'date' or 'COMPLETED and the date' but can't seem to work out how to do this.
...

**0**

votes

**1**answer

94 views

### Combining the ISBLANK and Date function

I have been searching through forums and can not figure out how to succesfully combine the two functions ISBLANK and a date function.
What I need to do is use this formula in google sheets for ...

**0**

votes

**1**answer

2k views

### how to highlight the cell with the max value

given a range of non adjacent columns (not sure if it matters if they're adjacent) i.e
F1:F100,J1:J100,N1:N100
for each row i'd like to highlight the cell with the maximum value.
i tried ...

**0**

votes

**3**answers

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

**0**

votes

**1**answer

842 views

### Conditional Formatting Cells with Different Values for Rows with the Same Value in Specific Column

I need to conditionally format cells with different values between the same columns, if their value for a specific column is the same.
Scenario
My spreadsheet is a contacts database, where each row ...

**0**

votes

**1**answer

324 views

### Excel Conditional Formatting: 3 color scale scoring fuzzy matched data for Windows [duplicate]

This question is posted as a spinoff from here - the post cited is about Mac where as this is about Windows:
Conditional Formatting: 3 color scale showing text relevance in Excel for Mac
Is ...

**0**

votes

**1**answer

3k views

### How can conditional formatting be used for duplicate cells on different sheets?

I have set up multiple tabs on excel 2013, I have created a conditional format to highlight box red when duplicate information is entered. However I would like this also to happen on the different ...

**0**

votes

**1**answer

66 views

### Conditional formatting in Excel 2013

Hi I want use conditional formatting. On this values:
everything works, but when i change values (mid and max values are similiar) to:
conditional Formatting do not works. What I do bad?

**0**

votes

**1**answer

27k views

### Conditional formatting to highlight the whole row if a cell is left blank

Could anyone tell me please how to highlight a row if the first cell in that row is missing a value?

**0**

votes

**3**answers

7k views

### For Excel how do I create a field that automatically generates a sequential number

How do I create a field that automatically generates a unique number when I enter a new record in a table ?
I have a list of numbers in the B column. I want the numbers in column A to automatically ...

**0**

votes

**2**answers

8k views

### Apply strike out text on row

I have a question about Excel 2007 and I'm not sure if its even possible, but if any community can help it's here.
I want to strike out all the text for all cells in a row if the text in column A ...

**0**

votes

**1**answer

243 views

### How do I format each cell in column FOO in Excel if the len() of the cell value is longer then BAR?

If this is the wrong place to ask this let me know.
Here is the formula I have right now:
=LEN($A$2)>$AB$11
Applies to:
=$A$2
That works great for the one cell. I need it to apply to each ...

**0**

votes

**1**answer

24 views

### Excel 2010 Conditional Formatting Cell color based on a group of text cells

Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has text values 'Yes', 'No', 'In Progress' I want to ...

**0**

votes

**1**answer

654 views

### If Function is not working in Excel

I had made a sheet to calculate factory workers timing and payment against working and over time.
First I made it in Excel 2013 and then I changed my Windows from 10 to 7 and also changed the ...

**0**

votes

**1**answer

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