**0**

votes

**2**answers

202 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

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

**5**

votes

**3**answers

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

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

168 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

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

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

**8**

votes

**3**answers

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

**7**

votes

**5**answers

19k 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)?

**6**

votes

**2**answers

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

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

34 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

500 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

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

**8**

votes

**1**answer

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

448 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

293 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

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

371 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

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

**12**

votes

**3**answers

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

**1**

vote

**1**answer

658 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

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

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

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

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

**2**

votes

**1**answer

978 views

### Conditional Formatting to highlight cells with highest frequency

I have an Excel table like the following:
1 2 3 4 5 6 7 8
----------------------
3 3 3 3 3 1 1 1
4 4 5 4 4 4 4 3
and I need a conditional style to highlight the items with the ...

**2**

votes

**1**answer

3k views

### Excel: Conditional Formatting (Highlighting) Values Based on Another Worksheet

I have a workbook that has two worksheets.
The first worksheet is simply a list of the first 78,498 prime numbers in a single column, A1-A78498.
The second worksheet has a grid of numbers from 1 to ...

**4**

votes

**2**answers

4k views

### How can I alternate grid background color in excel when a value of a single column changes?

How can I alternate grid background color in excel when a value of a single column changes?
Such as this:
I would want to do this with conditional formatting, but I can't figure out how to.

**1**

vote

**5**answers

3k views

### How to delete all data on hdd other than Windows 7 [duplicate]

Possible Duplicate:
What's the best way to completely remove everything from a computer, without re-installing?
I have to return my company laptop. It has windows 7 on it. I want a way ...

**1**

vote

**1**answer

124 views

### Is there a formula that I can use so that I can get a cell on Sheet 1 to have exactly the same formatting as a cell on Sheet 2?

I am using an excel spreadsheet to record skill competencies of staff. Sheet 1 will act as a "master" sheet reflecting the skill competencies of all staff (ie different employee in each column) and ...

**2**

votes

**1**answer

519 views

### Adding conditional formatting to the status line in GNU screen

In GNU screen in the status it is possible to put conditional things, such as
%?%F%{+b r}%:%{+b b}%?
%F is the test; if true it turns on bold red formatting %{+b r}, whereas if false it turns on ...

**6**

votes

**11**answers

51k views

### How to prevent cells from printing in Excel

How can I prevent the contents of specific cells (or entire row or column) from printing in Excel, while keeping them visible on the screen when I'm editing the file? Ideally I should be able to do ...

**1**

vote

**1**answer

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

**2**

votes

**3**answers

18k views

### How to hide number but keep Excel cell background color?

I got a sheet like the below figure. I want to hide all the number and just keep the background color. How can I do it?

**3**

votes

**2**answers

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

**2**

votes

**1**answer

201 views

### Conditional Formatting in Excel

I have a worksheet with a series of rows A1 - H1 etc and a drop down list which lives in H1, I would really like to change the cell styles of all the cells between A1 - H1 based on the value in H1.
...

**1**

vote

**2**answers

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

2k views

### Conditional Formatting of a Cell Based on Color Value in that Cell in Excel

Is is possible to format a cell based on one component of the RGB value inside of it. For example, let's say I have 3 cells - A1, A2, A3. In A1, I want the cell color to be the shade of red anywhere ...

**23**

votes

**2**answers

9k views

### Excel Conditional Formatting Escaping a Question Mark

I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn ...

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

419 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

**4**answers

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

**0**

votes

**1**answer

241 views

### How do I format each cell in column FOO in Excel if the len() of the cell value is longer then BAR?

If this is the wrong place to ask this let me know.
Here is the formula I have right now:
=LEN($A$2)>$AB$11
Applies to:
=$A$2
That works great for the one cell. I need it to apply to each ...

**34**

votes

**8**answers

151k views

### Find Items in one column that are not in another column

I have two columns in Excel, and I want to find (preferably highlight) the items that are in column B but not in column A.
What's the quickest way to do this?

**0**

votes

**1**answer

625 views

### Outlook 2007 - Conditional Format based on Users declining a meeting

I recently set up a meeting with a colleague but must have ignored the fact that he had declined. So I showed up to the meeting alone.
Is there any way to conditional format my Outlook 2007 calendar ...

**3**

votes

**2**answers

8k views

### Excel - conditional formatting in Shapes?

For a long time, I didn't think it was possible to have a Shape (e.g., Text Box) have a value set by formula, but it turns out you can. Similarly, it appears that you can't apply conditional ...