**2**

votes

**1**answer

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

**2**

votes

**2**answers

67 views

### Color every Cell that contains the number '0'

My problem is most likely a completely trivial one, but at the moment I'm completely out of ideas.
I want to color all cells in a certain working area depending on what single digit number they ...

**2**

votes

**1**answer

686 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

**1**answer

132 views

### how can I use conditional formatting in excel to search for a list of values

I have two columns of data, one which contains a large number of values (column a), while the other contains a smaller amount of values(column e). I was wondering if anyone knew how to search for and ...

**2**

votes

**1**answer

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

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

**2**

votes

**1**answer

975 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

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

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

**2**

votes

**2**answers

64 views

### Excel conditional formatting rows to highlight weeks in different colours

I am trying to automatically format the rows of my worksheet based on the date in the A column.
I am using the following to highlight the weekends.
=WEEKDAY($A6,2)<5
This works however I also ...

**2**

votes

**2**answers

103 views

### A Conditional Format to change the background color but keep the Date format

I have and OpenOffice Calc document that has a "table" with Text, Numeric and Date columns. I have a conditional format making every odd row have a different background color so it will be easier to ...

**2**

votes

**1**answer

1k views

### How can I use Excel data bars to format cells with text values?

I'm creating a spreadsheet for project planning and have a column that lists estimated effort as follows:
Unknown
Very High
High
Medium
Low
Very Low
None
I like the visual cues provided by ...

**2**

votes

**3**answers

6k views

### Vertical Histogram in Excel with Conditional Formatting

I'm able to do data bar conditional formatting in Excel 2010, but I can't figure out how to switch the bar axis to make it vertical. Is there any way around this? Can I simulate a vertical histogram ...

**2**

votes

**1**answer

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

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

**2**

votes

**1**answer

50 views

### Highlight rows that don't match other sheet

I'm not sure if this is possible, but I have two spreadsheets that I need to compare in a few different ways.
Here is the scenario:
**Sheet 1**
Column O=Claim Number;
Column P=Reserve Indemnity; ...

**2**

votes

**2**answers

43 views

### Highlight duplicates only if the header is the same

I'm attempting to use Conditional Formatting to highlight a duplicate entry if and only if the Header to both columns are the same.
In my example below, this is a season long NFL contest of picking ...

**2**

votes

**1**answer

33 views

### Excell 2007 conditional formatting

I have created an excel spreadsheet where in each cell there is a formula which gives a value with two decimals. I need to use the conditional formatting to highlight the cells in which the second ...

**2**

votes

**1**answer

865 views

### Conditional format cells, based on their text value in Libre Office

This is driving me crazy. I try to set up the simplest conditional rule, but it will not work: format cells based on their text value.
The sense is to colorize a separator line. Until now I had ...

**2**

votes

**1**answer

278 views

### How to apply conditional formatting only to cells that contain a subtotal formula

I have a list of values, I have to alternate color of each row (that works fine).
In that list I also have subtotals, calculated using the SUBTOTAL function.
How would I be able to give just the ...

**2**

votes

**1**answer

29 views

### How to show a value of a Cell as it's displayed

I have a cell A2 that shows the value 001. I want to concatenate that value of 001 to a string to show REQ-001. The cell that I want to show this string I have =CONCATENATE("REQ-",A3). But the ...

**2**

votes

**1**answer

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

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

**3**answers

7k views

### EXCEL: How to conditional format a thick bottom border to an entire row based on one column value? [duplicate]

Possible Duplicate:
Excel conditional formatting to highlight entire row if one date is not equal to another date in that row
I have the following rows...
1 AA 12 13 4 7
1 A ...

**1**

vote

**3**answers

259 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

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

**1**

vote

**2**answers

447 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

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

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

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

**2**answers

18 views

### Fill a date-filled cell red if older than 30 days and no date paid entered in another cell

I have two cells in Excel that are for dates (date billed and date paid). I need the date billed cell (say A1) to fill red if it contains a date and that date is older than 30 days and nothing has ...

**1**

vote

**1**answer

1k views

### Alternate Row Colors of Duplicate Data in Excel

I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...

**1**

vote

**1**answer

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

**1**

vote

**4**answers

7k views

### Preserve conditional formatting on cut-paste

I have some data from different sources that I'm trying to line up to get a good handle on which fields they have in common and which they don't. To make it easier to see rows, I set up a conditional ...

**1**

vote

**2**answers

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

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

**1**

vote

**1**answer

35 views

### In excel 2010 how do I change the cell colour to red if the date entered is 2 weeks or more in the past? [duplicate]

I have a spread sheet and I want the colour of the cell to change to red when the date entered is two weeks (or more) ago as this will immediately show me when work is overdue so I can chase it up.
...

**1**

vote

**1**answer

27 views

### Excel Conditional formatting if in list

I have a list of values J1:J100 and another list of values E1:E75
If a cell in column J matches a cell in column E, I would like this cell to be highlighted.
Any ideas what formula to enter into ...

**1**

vote

**1**answer

57 views

### Conditional formatting based on specific cells

Is it possible to set conditional formatting based on a value written in a specific cell?
I would like to colour the rows of saturday and sunday and not colour the working days.
The condition is ...

**1**

vote

**1**answer

117 views

### Excel: Conditional formatting not filling in cells if adjacent cell is filled

I am trying to fill a pair of cells in if both are blank. Which works unless the cell next to the pair is filled in. How do I go about resolving this issue?
Formula:
=AND(ISBLANK(F2),ISBLANK(G2))
...

**1**

vote

**1**answer

72 views

### Excel - if cell is empty AND if cell is empty - Colour Row

I'm a complete novice when it comes to conditional formatting. I've found a similar question that allowed me to change the colour of the cell, but not the row.
Here's a snipped of what my sheet will ...

**1**

vote

**1**answer

73 views

### Higlight a specific cell based on ADDRESS() return value

I want to give a style (highlight) a specific cell based on a date value. This date is, say, in cell
A1.
To achieve this, I thought I would calculate the address of the cell I want to style with the ...

**1**

vote

**1**answer

225 views

### Conditional Formatting on a Specific Character only

I have the following Excel table :
> N
1 Open / Closed
2 O
3 C
4 O
5 O
6 C
I want to put a Conditional Formatting, putting in GREEN ...

**1**

vote

**2**answers

1k views

### Color scale for text values in Excel

I would like to apply color scale on text values. But unfortunately, it works only on numbers!
I’m doing this to easily identify the repeated values sorted by other column.
This image explains the ...

**1**

vote

**2**answers

458 views

### How do I format cells in one column based off cells in another column?

So I found some similar questions to this already answered here, but they don't go deep enough for what I want to do, and was hoping to find some more help.
At a high level I want to format some ...

**1**

vote

**2**answers

23k views

### Excel conditional formatting if value is between or equal to values

I have been trying to use conditional formatting to create a Gantt chart. So far I have not been very successful. Here is a screenshot of part of the chart:
The current formatting is hand made.
I ...

**1**

vote

**3**answers

1k views

### Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green ...

**1**

vote

**1**answer

517 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

**2**answers

23k views

### Excel: Conditional formatting using icon sets?

I would like to format the Subtotal row such that within each Subtotal cell is the total and an "icon set" icon that will show if that month is greater than or less than the previous month's total.
...

**1**

vote

**2**answers

65 views

### Single condtional format rule to apply to a range of cells

I'd like a single conditional format rule I can apply to a range (a columns) so that a number appears in bold if it is greater that the number to its left, like this:
100 200
200 190
200 300
Is ...