A feature in Microsoft Excel, LibreOffice Calc, and some other spreadsheet programs that allows the user to automatically add color, text styles, and so on to certain cells or ranges of cells based on the data in the spreadsheet.

learn more… | top users | synonyms

2
votes
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
3answers
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
1answer
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
2answers
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
2answers
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
5answers
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
2answers
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
2answers
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
1answer
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
1answer
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
4answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
2answers
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
3answers
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
1answer
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
2answers
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
2answers
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 ...