# Tagged Questions

**1**

vote

**2**answers

25 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

20 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

50 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

**1**answer

79 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

**1**answer

46 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

151 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

39 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

36 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

53 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

53 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

378 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

56 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

220 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

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

**1**

vote

**2**answers

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

**4**

votes

**1**answer

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

13 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

164 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

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

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

**-1**

votes

**1**answer

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

**1**

vote

**1**answer

161 views

### Conditional formatting for entire row based on fixed column

How do I create the following conditonal formatting:
If the date in G3 is older than today, turn all of row 3 red
So in other words I want my entire row to be formatted based on the value in the ...

**0**

votes

**3**answers

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

**2**

votes

**1**answer

274 views

### Excel Conditional Formatting cell's value that has number suffix, like 99th, 23rd, or 1st

So I am filling a cell with Blue, Green, Yellow, or Red based on a Percentile Rank that is returned, that is numbers like ( >=90th=Blue, >=60th=Green, >=30th=Yellow, <30th=Red )
Currently ...

**0**

votes

**2**answers

174 views

### Conditional format cells that are duplicated in every column

I have a table in which every column describes a product and every row is responsible for one attribute of the product. I want to highlight cells which are duplicated in every column.
I have for ...

**4**

votes

**1**answer

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

**1**

vote

**1**answer

287 views

### Excel conditional formatting based on a formula including a range containing the current cell

I want to change the background of a cell as long as the running total in that column from start to that cell is less than a limit specified in a different cell.
Conceptually, the formula should look ...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

5k views

### Excel: Conditional formatting using icon sets?

I would like to format the Subtotal row such that within each Subtotal cell is the total and an "icon set" icon that will show if that month is greater than or less than the previous month's total.
...

**1**

vote

**2**answers

51 views

### Single condtional format rule to apply to a range of cells

I'd like a single conditional format rule I can apply to a range (a columns) so that a number appears in bold if it is greater that the number to its left, like this:
100 200
200 190
200 300
Is ...

**2**

votes

**3**answers

3k views

### Is it possible to save conditional formatting rules for reuse in a new workbook?

I want to make some rules that I can haves saved that I can easily apply to new workbooks as needed. It's a pain doing it how I currently do where I'm always having to go back through and recreate ...

**-2**

votes

**1**answer

81 views

### Conditional date formatting

The following needs to happen:
Enter a goal date in cell C1 and enter actual completion date in D1 when project complete
D1 will remain blank until project is complete.
If D1 is blank:
STATE 1 -- ...

**0**

votes

**1**answer

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

**6**

votes

**1**answer

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

**2**

votes

**3**answers

350 views

### How to format a date field based on whether the date has passed?

I am trying to create an Excel spreadsheet where, when I input a date:
if that date is within 30 days it will go yellow,
if the date has already gone then it goes red, and
if the date is more than ...

**0**

votes

**1**answer

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

**2**

votes

**1**answer

96 views

### how can I use conditional formatting in excel to search for a list of values

I have two columns of data, one which contains a large number of values (column a), while the other contains a smaller amount of values(column e). I was wondering if anyone knew how to search for and ...

**3**

votes

**1**answer

65 views

### Formatting Entire Row with Multiple Rules

I would like to change the formatting (specifically text color) for an entire row based on which selection is chosen from a drop down list in Column C. Example:
If C2 equals 'XX'(one of the ...

**1**

vote

**3**answers

1k views

### EXCEL: How to conditional format a thick bottom border to an entire row based on one column value? [duplicate]

Possible Duplicate:
Excel conditional formatting to highlight entire row if one date is not equal to another date in that row
I have the following rows...
1 AA 12 13 4 7
1 A ...

**1**

vote

**1**answer

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

**2**

votes

**4**answers

415 views

### Is it possible to have a conditional formatting cell “visually cycle” through all the formats that evaluated true?

Like the title says, "In Excel, when a cell has multiple conditional formatting rules that evaluate true, is it possible to have the cell "visually cycle" through all the formats that evaluated true? ...

**1**

vote

**0**answers

50 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

**3**answers

188 views

### How to create a conditional format in excel 2007 from another cell

I have a sheet with 4 fields spanning A3:D3
in D3 I have a conditional format that turns the cell yellow if it equals the word "no contact"
How can I get Cells A3:C3 to also turn yellow if this is ...

**1**

vote

**0**answers

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

votes

**1**answer

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

vote

**1**answer

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

**2**

votes

**1**answer

134 views

### Excel IF Condition

In Excel, how would I perform the following using the IF condition?
If cell is empty then set the background color to red.
If cell has a value then set the background color to green.

**2**

votes

**2**answers

2k views

### Vertical Histogram in Excel with Conditional Formatting

I'm able to do data bar conditional formatting in Excel 2010, but I can't figure out how to switch the bar axis to make it vertical. Is there any way around this? Can I simulate a vertical histogram ...

**0**

votes

**2**answers

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

**1**

vote

**1**answer

217 views

### How to do conditional formatting based on several criteria? [duplicate]

Possible Duplicate:
Formatting a column based on another columns cell TEXT (not value) in Excel
How can I implement the following as an Excel formula?
If column j="renew" or "-" AND the ...