# Tagged Questions

**1**

vote

**1**answer

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

**0**

votes

**1**answer

37 views

### Conditional formatting

What I am looking to do is have a conditional format set up so that if row G contains the value "In progress" "With 3rd Party" or "Identifying" and row H, J or K contain no value then highlight rows A ...

**1**

vote

**1**answer

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

**0**

votes

**1**answer

143 views

### Conditional Formatting for one cell value in a list, another cell blank

Looking for how to do Conditional Formatting for the following rule:
If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. ...

**0**

votes

**2**answers

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

**3**

votes

**2**answers

283 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

94 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

**2**answers

49 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

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

**1**

vote

**1**answer

59 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

178 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

**1**answer

95 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

**0**answers

259 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

**1**answer

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

**1**

vote

**0**answers

117 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

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

**2**

votes

**3**answers

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

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

204 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

**1**answer

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

**0**

votes

**2**answers

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

**3**

votes

**2**answers

4k views

### Excel: conditionally format a cell using the format of another, content-matching cell

I have an Excel spreadsheet where I’d like to be able to create a “key” of formatted cells with unique values, and then in another sheet format cells using the key formatting.
So for example, my key ...

**5**

votes

**1**answer

1k views

### Conditional formatting to highlight the whole row

I would like to highlight the whole row 5 if J5="T".
I used to do it with the old Excel, the 2010 conditional formatting ignores it. So my rule is like this and it does not work. I used the formula ...

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

**0**

votes

**2**answers

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

**0**

votes

**2**answers

237 views

### Conditional Formatting Non Contiguous Ranges

I have a large spreadsheet, which came prepopulated with data. What I would like to do is the following. If I select I7:15, and apply this conditional formatting
Cell Value is equal to =G7, colour ...

**-1**

votes

**1**answer

465 views

### Excel 2007 conditional formatting formula problem

I have the following problem. I have a sheet where the current month should be highlighted. For this I used the formula for conditional formatting. The formula for the first three months is like this:
...

**1**

vote

**3**answers

306 views

### Excel Conditional Formatting for Cell condition in Range

How do I reference another cell in my conditional formatting?
I want an entire range to highlight in green if a particular cell in that range is populated with "y".

**1**

vote

**2**answers

728 views

### Excel conditional formatting of row

Can someone please tell me how to highlight multiple cells in a row based on some values in any one of a given number of cells?
For example, if in Row 2 any of the cells from D2 to L2 have value "A" ...

**1**

vote

**4**answers

3k views

### Excel: struggling to use CF to highlight differences between columns in the same row

I have a list of vaules in column A and column B. I need to highlight where there is a difference between values that are in the same row.
I've used a simpe formula in B1: $A1<>$B1 (format bold). ...

**3**

votes

**2**answers

2k views

### Excel conditional formatting based on a formula

I would like to use Excel's conditinal formatting of a particular column based on values in two other columns.
I have values in columns A, B, C and D.
column A has text values (any value user ...