**3**

votes

**2**answers

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

**2**

votes

**1**answer

714 views

### Excel conditionally format a row based on a cell

I have a table something like this:
text1A | text2A | value1A | text3A | value2A
text1B | text2B | value1B | text3B | value2B
text1C | text2C | value1C | text3C | value2C
If the value in column 3 ...

**2**

votes

**1**answer

1k views

### Transferring Conditional Formatting (without the cell value) in Excel

If I have 3 layers of conditional formatting in a cell (B2) is there a way of transferring the format of cell (B2) to another cell (A2) without copying across the value in the original cell (B2).
...

**0**

votes

**0**answers

19 views

### How to apply Conditional Formatting to a row of data if a certain cell is blank [duplicate]

Possible Duplicate:
Conditional formatting to highlight the whole row
Here's the problem I am facing:
I want to highlight A1:M1 if L1 is blank, A2:M2 if L2 is blank, A3:M3 if L3 is blank, ...

**2**

votes

**1**answer

6k views

### How can I express “if column A is greater than column B, format column B”

I'm having trouble with conditional formatting- so would really appreciate some guidance!
I want to format the numbers in column B, relative to the values in column A.
So if B is equal to or greater ...

**1**

vote

**1**answer

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

**4**

votes

**1**answer

2k views

### Excel 2010 conditional formatting: selectively highlighting duplicates

I'm using Excel 2010 and would like to know if there's any way I can choose conditional formatting to highlight only instances of duplicates when it's found in ALL the columns I chose?
For instance, ...

**3**

votes

**1**answer

131 views

### Is it possible for Excel to check conditional formatting on key press?

I have defined a conditional formatting for a cell like equal to 'a' but it seems Excel checks conditional formatting after I select another cell (and un-focus the cell which has conditional ...

**-1**

votes

**1**answer

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

**1**

vote

**0**answers

2k views

### Excel conditional formatting, greater than a year

I am working on a spreadsheet that logs the dates parts were sent out and would like to apply conditional formatting to the dates.
I would like if over 3 years ago, if over 2 years ago, if over 1, ...

**2**

votes

**2**answers

2k views

### Conditional formatting issues in Excel

I seem to be having a problem with conditional formatting in Excel 2010. I have a set of date points, percentages between 1 and 100. I applied three rules in the following order,
if greater than ...

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

**1**

vote

**1**answer

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

**2**

votes

**1**answer

2k views

### How to change cell color based on today's date in Excel 2010

How do I Change cell color in Excel 2010 for upcoming or past dates based on 90 days from today. I would be great if I could use 2 color scale but one color will be fine.

**4**

votes

**2**answers

4k views

### LibreOffice conditional formatting based on string value: strange behavior

Here is what happen when I apply conditional formatting:
(yes should appear green, no should appear red)
I have made sure AutoCalculate is enabled.
Is it a known bug, or am I misunderstanding ...

**0**

votes

**2**answers

2k views

### How can I set up conditional formatting to highlight a range only if all its cells are empty?

I am new to conditional formatting and having a hard time. I have 6 columns with 100 rows. What I would like to have happen is to highlight the row in one color if there is no data in it at all. If ...

**0**

votes

**2**answers

2k views

### Conditional formatting 2 different colors every two rows

I want to apply conditional formatting to change the background color of alternating rows on a spread sheet. The rows will alternate between two colors (yellow and green) two lines each.
This is the ...

**1**

vote

**2**answers

724 views

### Conditional Formatting Alternating Rows in Excel

I want to apply conditional formatting to change the background color of alternating rows on a spread sheet. The rows will alternate between two colors (yellow and green).
The only problem is, that ...

**1**

vote

**1**answer

3k views

### customize excel 2010 highlight track changes

Is there any way to customize how Excel highlights cells on Track Changes? My customer requested us to "highlight anything you've changed by changing text color to red," and I'd like to implement ...

**2**

votes

**1**answer

211 views

### Format cell in Excel if contents are a number or a function

I understand conditional formatting but I don't see how it can help me. I'm looking at a sheet with many product entries and for most of them I get values from a table (vlookup) while for others I ...

**0**

votes

**1**answer

106 views

### How to apply conditional fomatting for a MAX value to a range of cells

I have a table that is five cells wide by twenty high with a sum function at the end (e.g. cel A20). I want to highlight the column that results in the highest SUM. How do I use conditional formatting ...

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

**1**

vote

**3**answers

10k views

### conditional formatting for subsequent rows or columns

I have data in a range of cells (say six columns and one hundred rows). The first four column contains data and the sixth column has a limiting value. For data in every row the limiting value is ...

**0**

votes

**2**answers

210 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

178 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

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

**4**

votes

**3**answers

5k views

### Highlight a row where a value changes relative to previous row (Conditional Formatting?)

I have a spreadsheet with lots of data. The data is grouped so that all the rows with a certain value in one column (say C) are grouped together. I want to highlight the "boundaries" - i.e., the first ...

**2**

votes

**1**answer

1k views

### Excel Conditional Formatting of Rows based on multiple columns

I have a spreadsheet with columns A-K and rows 1-56. If any value in D3 through J3 goes below 0, I want the entire row (A through K ) to have a special format. I've gotten close in Excel 2010 by using ...

**2**

votes

**1**answer

158 views

### Excel conditional formatting when part of validation list

I'm trying to use conditional formatting on a cell that is populated via a validation list. It will not format. I try the exact same formatting on another cell which is not populated from a drop ...

**3**

votes

**1**answer

2k views

### Excel conditional formatting to highlight entire row if one date is not equal to another date in that row

I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...

**1**

vote

**1**answer

2k views

### Alternating Row Colour with Conditional Formatting in Excel 2011 for Mac?

Does anyone know how to create a formula that causes the row colour to alternate when using conditional formatting?

**5**

votes

**3**answers

13k views

### Microsoft Word 2010 - Conditional Formatting

Is there a way to apply conditional formatting to a table in Microsoft Word 2010, in much the same way that it is possible in Microsoft Excel?
Thanks.

**3**

votes

**4**answers

6k views

### Conditionally format a cell if it contains formula

Is it possible to conditionally format a cell if the cell contains formula (to alert myself and other users when updating the cell)?

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

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

**0**

votes

**0**answers

32 views

### Excel: use formula in cell format [duplicate]

Possible Duplicate:
Excel: use formula in cell format
Is there a way to use a formula as a cell format?
AFAIK, conditional formatting allows only static format applied based on some ...

**-1**

votes

**1**answer

449 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

**1**answer

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

**3**

votes

**1**answer

10k views

### Conditional formatting of TRUE / FALSE values in an Excel 2010 range

I have a range containing formulas that evaluate to TRUE or FALSE.
How would one apply conditional formatting to this range, so that TRUE cells are Green, and FALSE cells are RED?

**1**

vote

**2**answers

337 views

### Advanced spreadsheet auto-formatting

Is it possible to autoformat spreadsheet like this
IF A1 = C1 then A1:E1 cells background becomes light gray
I use OO Calc, but it's ok if you know how to do it in MS Excel or Google spreadsheet

**1**

vote

**1**answer

241 views

### conditional formatting of entire row from a cell's value in that particular row in Excel 2007

I have viewed the answer for a similar question. If I have several rules for a particular row, (e.g. if cell A2 is 1 then the row is red, if 2 then row is blue, if 3 then row is green, etc...). Having ...

**2**

votes

**1**answer

2k views

### How do I use conditional formatting in a spreadsheet based on dates?

I have a spreadsheet in OpenOffice V3.3.0 (used in Windows 7 32 bit). One column contains dates (in the format: 14 August 2011 ) and I want to use conditional formatting on those cells depending on ...

**1**

vote

**3**answers

289 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

644 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" ...

**5**

votes

**1**answer

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

**1**

vote

**1**answer

466 views

### Excel conditional formatting multiple repeating rows

I'm using Excel 2010
I have a monthly menu. menu days are listed by row with 2 menu items list for each day.
Col-C Col-D
Day 1
Cheesburger
Hamburger
Day 2
Taco
Quesadilla
Day 3
...

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

**0**

votes

**2**answers

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

**2**

votes

**1**answer

2k views

### Excel: Detect #N/A (German: #NV) for conditional formatting

I have a huge Excel sheet where I regularly import mass data into. This data is input to calculations per row. Sometimes, the imported data results in a #NV error in the calculated data.
I would ...

**1**

vote

**1**answer

971 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: ...