**0**

votes

**2**answers

23 views

### Excel 2010 Custom Formula / Conditional Formatting to highlight data that is greater than Twice the Value of Original Cell

I am trying to figure out how to indicate cells that are greater than twice the value when compared to a specific cell. For example, a value of .1 compared to .18 would be OK but .1 compared to .2 ...

**0**

votes

**2**answers

89 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

381 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

277 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

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

**-1**

votes

**1**answer

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