**0**

votes

**2**answers

18 views

### Excel Formating - How do I compare 2 cells and highlight one of them based on the date in 1 Col being further out then the date in the other?

I have a spreadsheet tracking multiple dates for about 150 people. I am having a problem however getting dates in Col I to highlight if they are going to be past the date in Col P.
I want Col I Row ...

**0**

votes

**2**answers

43 views

### Selectively find duplicates across columns

Column A has the product ID. There are 102 other columns with other data. Column A will be unique unless some data was changed. In that case, there will be 2 rows with 99% of the columns are ...

**0**

votes

**2**answers

295 views

### Highlight row when two columns contain specified values

I have 2 columns "N" and "O" . Both columns can contain "x". If column N has an x and column O is null then highlight the line. This should apply to the entire worksheet. Thanks so much in advance. ...

**0**

votes

**2**answers

204 views

### Restricting symbols allowed in cells of Excel spreadsheet

I need to format some Excel cells to allow currency (decimal point) only to be entered. Some employees completing the form enter a colon (:) instead of a decimal point which then results in an ...

**0**

votes

**2**answers

176 views

### Finding duplicates in a column where the cells hold a formula

I have a workbook with 3 sheets. Sheet "PS", column A contains a list of player names that stays static. Each week, each person in column A sends me a name from an available list. They are allowed ...

**-1**

votes

**2**answers

2k views

### Excel conditional formatting comparing date and time to current date and time

I have a style sheet in which I have to dates with times
-----------------
29/09/2011 12:00
29/09/2011 14:00
-----------------
If current date and time is 29/09/2011 11:50 then row is green
If ...

**2**

votes

**1**answer

158 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

43 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

**1**answer

125 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

**1**answer

232 views

### Format columns matching drop down value Excel 2003/VBA

I have a drop down in Excel to allow user to select a comparison bank. When a bank is selected for comparison all occurrences of that bank are highlighted in the tables below the drop down. Here is ...

**0**

votes

**1**answer

20 views

### How to suppress repeating values in a manner that takes into account previous conditional formatting? (Google Calendar-like scheduling blocks)

I'm in the process of creating a scheduling template.
I'm trying to figure out how I create a conditional formatting formula for suppressing repeating values that takes into account the conditional ...

**0**

votes

**1**answer

45 views

### How can I set up this conditional formatting in Excel 2010?

We create sections by highlighting an area in Excel 2010 and clicking ALL BORDERS. We want to set it so that any time you type "REPLA" between columns J and Q, the line that "REPLA" is in will Fill ...

**0**

votes

**1**answer

77 views

### How to change a row of cells on excel 2010 depending on different cell data

Can anyone help me with a problem I'm having on excel 2010 please?
I am trying to change the colour of part of a row of cells when certain data is input. For example I want cells A13 to G13 to ...

**0**

votes

**1**answer

80 views

### Excel - Using condtional formatting in a count down of the date

So i am using Excel Mac 2008, i want a formula where i enter a date and if the date is less than 5 days from today, it turns bold and red. can anyone help me figure this out?
I have a formula that ...

**0**

votes

**1**answer

77 views

### How do you have a conditional formatting rule in Excel apply to a discontiguous range of cells?

I have an Excel workbook with 10 worksheets.
Each sheet has a column named status.
Depending on the value of status ("on time", "at risk", "completed"), I want to format the cell background with a ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

146 views

### Excel cell formatting to fill color

I'm doing some excel formatting, with below formula being used:
=IF(OR(ISBLANK(E23),ISBLANK(E24),ISBLANK(E25)),"Section Incomplete","Section Complete")
Basically, When the cells E23, E24 and E25 ...

**0**

votes

**1**answer

209 views

### Conditional Formatting to highlight dates past due

I have a spreadsheet which indicates when dates listed in Column N are coming up within the next 30 days (red, italic text) or are overdue (red, italic text and yellow cell fill).
I have achieved ...

**0**

votes

**1**answer

596 views

### Conditionally formatting a cell in a pivot table based on a range of cells grouped by a Column Label

Within my pivot table I currently have cells conditionally formatted- Value=1, Green and Value=0, Yellow. I would like to conditionally format based upon all the values within a row label underneath a ...

**0**

votes

**1**answer

1k views

### Excel 2007 conditional formatting rule using formula to highlight a row based on matching text between columns

I am checking accountability of whether my office is creating source acknowledgement reports "C", recommended whenever a reference document "A" is read, and required whenever an article "B" is ...

**0**

votes

**1**answer

263 views

### Conditional Formatting with more than one variable

If ( cell A10 =2 ) AND ( cells C10:c15 through d10:d15 are blank)
Then color cells c10:15 through d10:15 red
I can do one or the other but can't figure out how to make it meet both criteria prior ...

**-1**

votes

**1**answer

698 views

### Set an Excel cell's color based on multiple other cells' colors

I have an Excel 2007 spreadsheet for a list of products and a bunch of factors to rate each one on, and I'm using Conditional Formatting to set the color of the cells in the individual attribute ...

**-1**

votes

**1**answer

170 views

### Can someone tell me why this conditional formatting is wrong? Date ranges

I'm just literally doing a 3-color scale like so:
Minimum: =($L$3-TODAY())<7
Midpoint: =($L$3-TODAY())<14
Max: =($L$3-TODAY())>14
I thought this would be correct but it won't format ...

**3**

votes

**0**answers

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

**2**

votes

**0**answers

115 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

9 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

27 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

85 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

263 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

53 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

213 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

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

45 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

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

**0**

votes

**0**answers

182 views

### VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below).
Please note that:
Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table'
The number of columns, ...

**0**

votes

**0**answers

155 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

**0**answers

73 views

### Using variables to conditionally format Pivot Table in Excel 2007

I have data in a Pivot Table which I need to conditionally format. How can you do this using one column as a variant to determine the colour of the corresponding cell (e.g. Region and then Month, then ...

**0**

votes

**0**answers

23 views

### my toggle formula appears to be interfering with my conditional formatting

My toggle formula appears to be interfering with my conditional formatting.
This formula
{ =IF(K805=TRUE, "8 Cmplt", "2 Pending") }
yields me a working toggle button but it doesn't turn the ...

**0**

votes

**0**answers

29 views

### Copy the results of conditional formats which use sums to colour cells

I have set up a number of rules in some conditional formatting which results in colouring cells on a sheet of about 2,500 rows. I need to be able to copy the resulting formatting colours, to issue ...

**0**

votes

**0**answers

49 views

### Use the formatting from data table cells for drop down table results

I am setting up a risk ranking table and risk analysis spreadsheet in Excel 2010
The user selects from two drop down boxes (liklihood and consequence) and it gives the corrosponding result. I have ...

**-2**

votes

**0**answers

10 views

### Excel Column Formatting

I am looking to Format a column of text in excel for example
A
ABC123
123DGF
ABC124
NMO445
B
Corp
Acct
Corp
HR
I want excel to notice the text entered in column A and then ...