# Tagged Questions

**-1**

votes

**1**answer

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

**4**

votes

**1**answer

272 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

**0**answers

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

**2**

votes

**1**answer

376 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

**1**answer

863 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

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

**0**

votes

**1**answer

684 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

**2**answers

323 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

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

**1**

vote

**3**answers

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

**0**

votes

**3**answers

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

**-1**

votes

**1**answer

809 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

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

**1**

vote

**1**answer

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

**2**

votes

**1**answer

8k views

### Formatting a column based on another columns cell TEXT (not value) in Excel [duplicate]

Possible Duplicate:
Excel 2010 conditional formatting: selectively highlighting duplicates
I have dates that are running off a formula in that column based on information it's collecting ...

**0**

votes

**1**answer

2k views

### How to let Excel 2007 display a certain text as long/soon as a cell is empty? [duplicate]

Possible Duplicate:
custom format for cells with nothing in them without using conditional formatting
I'd like Excel 2007 to display a certain text like "" as long as a cell is empty.
So ...

**0**

votes

**1**answer

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

vote

**1**answer

116 views

### How to use conditional formatting in excel?

I am trying to make a spreadsheet black out non-needed information for individuals that meet a certain criteria. Their criteria is in column A and I need it to void cells B10:15 through C10:15 and ...

**1**

vote

**1**answer

753 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

**1**answer

623 views

### How to compare cell contents in Excel?

I have an Excel sheet. Row number 2 contains date values in each cell. For each cell in the sheet I want to check if the value in row 2 in my column equals some cell (let's say EG67, also dates).
How ...

**0**

votes

**1**answer

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

**5**

votes

**1**answer

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

**1**

vote

**1**answer

479 views

### How can I set conditional formatting to check for equality between columns?

I have a dataset like this in Excel:
A B
1 X X
2 X Y
3 Y X
4 Y Y
I want to set up conditional formatting such that rows 1 and 4 will be highlighted as green because their A and B cells are ...

**5**

votes

**1**answer

18k 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 the cells having a distinct value a unique color without manually creating a conditional ...

**0**

votes

**2**answers

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

**1**

vote

**1**answer

985 views

### Conditional format - change a cell to specific color based on formula

I need to color a cell in Excel 2007 based on a statement like, if B6=H and C6=g then color A6 Blue
I have no idea what the proper script would be but here is my guess that does not work: ...

**1**

vote

**1**answer

126 views

### Excel 2007 formatting using a range

I'm formatting a calendar on multiple sheets in excel, with the weekends highlighted. I'd like to format all the sheets from a table of 1s & 0s I generated to match different years. Unfortunately, ...

**1**

vote

**2**answers

3k views

### Excel Conditional Formatting Offset Greater than

I need to create a conditional formatting rule that will apply some color if the cell to the left has a value greater than 500, however it is not accepting my formula:
=OFFSET(0,-1) > 500
Can ...

**1**

vote

**1**answer

1k views

### Excel 2007 Conditional Formatting is not properly using custom formula provided

In Excel 2007, I want to conditionally color a row if it is odd numbered and then vary the coloring depending on if a specific cell (in column E) in that row contains a number (green) or empty(red). ...

**0**

votes

**3**answers

382 views

### CF: Cell STATUS + Cell DATE compared to NOW(DATE) = Colour

If the status in cell $D5 is "AWAITING FEEDBACK" I want to compare the DATE in cell $H5 against TODAYS DATE and CONDITIONAL FORMAT cell $H5 using the data bars formatting (colour to transparent).
If ...

**5**

votes

**2**answers

3k views

### Colour coding blocks of rows using conditional formatting

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore.
Using Excel ...