**1**

vote

**1**answer

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

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

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

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

**1**

vote

**0**answers

25 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

**2**answers

47 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

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

**1**answer

124 views

### Returning row values based on specific variables across multiple sheets.

I'm not entirely sure how to properly explain this, but here we go...
I'm trying to create a single budgeting document that allows me to manage purchasing and reconciliation for multiple projects. I ...

**2**

votes

**2**answers

96 views

### Highlighting Cells in Excel based on the Value Associated with the Cell

I have two sheets:
Users in their respective groups and
A compilation of those same users with an expiration date.
I'd like to highlight any cell in the the first sheet if their respective date ...

**0**

votes

**1**answer

61 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

**3**answers

159 views

### Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green ...

**0**

votes

**1**answer

46 views

### Conditional formatting in Excel 2013 for C8=blue and bold if C5>C2

This is part of a problem for college for which I can't find a solution.
Q: Use conditional formatting to format, in blue and bold, the value in column 8 for which the value in column 5 is greater ...

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

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

**2**

votes

**1**answer

34 views

### Excel 2013: Conditional Formatting changes after Query has run

I have conditional formatting on Columns A to N. Columns F to N are updated every time I open the spreadsheet as it pulls info from a SQL script. The problem I'm having is the following:
My ...

**1**

vote

**2**answers

39 views

### conditional formatting excel 2013

Is there a way to highlight a cell (possibly with conditional formatting) if one of the cells to the left of it has data, but it is empty?
for instance,
A B C D
...

**0**

votes

**1**answer

24 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

**2**answers

319 views

### Correct use of the Formula type in Excel Colour Scales

I'm trying to work some trickery in excel where each cell in a row is shaded based on how many have been completed:
So the idea is that as more of the columns in the row are ticked the whole row ...

**0**

votes

**2**answers

37 views

### How to put conditional formatting in a cell from another excel worksheet [closed]

It's hard to describe what I want, I'm not really familiar with Excel condition terms but it is basically just like this:
Worksheet= Dr. castro patient consultations
A B C D E
...

**-1**

votes

**1**answer

34 views

### Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...

**0**

votes

**1**answer

276 views

### How to format cells between two dates with a colour based on a value in vba?

(apologies if this question is difficult to understand, i'm unable to post an image)
I've tried finding a solution for this online but haven't had much luck.
Ideally, I want to use conditional ...

**0**

votes

**0**answers

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

**1**

vote

**1**answer

56 views

### Conditionnal Formatting with Dynamic Custom Formatted Date

My problem is that I want to color in red a list Custom Formatted Dates when the date is overdue.
For instance, I got two actions:
Buy Bread : Must be finished before 27/01
Buy Milk : Must be ...

**0**

votes

**1**answer

92 views

### Automatically format currency based on adjacent column - Excel

Using Excel and need a little help with a simple formula.
I know conditional formatting should do the trick here, however, I need help creating the exact formula for my need.
In column A I write the ...

**0**

votes

**0**answers

180 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

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

46 views

### Is it possible to get array/CSE formulas to work with conditional formatting?

I am trying to get a CSE formula to work with conditonal formatting. When using CSEs with cells, you hit CTRL+SHIFT+ENTER, but it appears that this key combination doesn't register in the conditional ...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

67 views

### Conditional formatting from another conditional format in Excel

In Sheet X I have a bunch of cells that are conditionally formatted with a fill color. I want the colors from Sheet X to be dynamically updated to Sheet Y and Sheet Z. That is, if cell X:3:D is ...

**3**

votes

**0**answers

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

**0**

votes

**1**answer

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

**4**

votes

**1**answer

251 views

### Excel: Dual graded color scales

Is it possible to do conditional formating for two graded color scales over the same cells?
For example I wish to conditionally format a cell such that its color is:
Green to Blue graded scale for ...

**0**

votes

**1**answer

52 views

### Conditional formatting duplicates for highlighted cells

I would like to conditionally highlight cells in a row. When the items in column B are duplicates then cells in columns B and C should be highlighted.
The value 7264 in column B has duplicates so ...

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

**1**

vote

**2**answers

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

**6**

votes

**1**answer

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

**0**

votes

**0**answers

72 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

14 views

### Conditional Formatting for entire ROW based on a cell entry number in a particular column [duplicate]

I am looking for how to have conditional formatting for a row if a certain cell has a certain number in it.
If a cell in column J has the number 284 in the cell, then the whole row (cells A - J ) ...

**1**

vote

**1**answer

196 views

### Change Excel Worksheet background colour based on values

Hopefully some one can help, but not sure if its possible. I'm using Excel 2010.
I want to change the background colour of a whole worksheet to green if the value in cell c20 is equal to or greater ...

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

**1**

vote

**0**answers

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

**2**

votes

**1**answer

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

**0**

votes

**0**answers

48 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

**2**answers

52 views

### Color every Cell that contains the number '0'

My problem is most likely a completely trivial one, but at the moment I'm completely out of ideas.
I want to color all cells in a certain working area depending on what single digit number they ...

**0**

votes

**0**answers

20 views

### How to conditionally format cells in excel based on whether contents is a formula or text/number [duplicate]

I'd like to conditionally format cells in Excel based on whether they contain a formula or not. If it's a formula I don't want formatting to change, if somebody overwrites contents of the cell with ...

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

**2**answers

481 views

### conditional format that would highlight an entire Row based on two criteria

Can someone help me please with a conditional format that would highlight an entire row in Excel 2010 if column B on my spreadsheet has any of these Letters (A,B,C,D,E,F,G,H,Z) and column C has the ...

**-1**

votes

**1**answer

2k views

### Changing a row's color depending on the value ( TEXT ) of a cell [duplicate]

In a cell, I have the choice of YES and NO for values. I would like to know how to change the background color for other cells in the same row depending on the value of the first without changing the ...