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

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
64 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
23 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
69 views

Excel 2013: Conditional Formatting changes after Query has run

I have conditional formatting on Columns A to N. Columns F to N are updated every time I open the spreadsheet as it pulls info from a SQL script. The problem I'm having is the following: My ...
2
votes
0answers
575 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
0answers
123 views

Outlook conditional formatting for meetings outside normal working hours

I'm trying to get meetings that start before 10:00 AM highlighted in red. I've tried to use the Conditional Formatting feature; in the advanced tab I selected the "Start" field and "on or before" ...
2
votes
1answer
160 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
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
3answers
3k 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
209 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
4k 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
366 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
778 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
1answer
64 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
2answers
809 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
3answers
14k 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 ...
1
vote
1answer
262 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
24 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
32 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
989 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
751 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
3answers
2k 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
1answer
308 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
1answer
11k 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
56 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 ...
1
vote
1answer
280 views

How to do conditional formatting based on several criteria? [duplicate]

Possible Duplicate: Formatting a column based on another columns cell TEXT (not value) in Excel How can I implement the following as an Excel formula? If column j="renew" or "-" AND the ...
1
vote
1answer
137 views

How to use conditional formatting in excel?

I am trying to make a spreadsheet black out non-needed information for individuals that meet a certain criteria. Their criteria is in column A and I need it to void cells B10:15 through C10:15 and ...
1
vote
1answer
517 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 ...
1
vote
1answer
536 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
4answers
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). ...
1
vote
1answer
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: ...
1
vote
2answers
3k 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
1answer
1k 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 ...
1
vote
1answer
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). ...
1
vote
2answers
106 views

How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date). The chart is printed or worked on at ...
1
vote
1answer
78 views

Conditional Formatting if one time is greater than the other

I'm attempting to get excel to conditionally format a cell based on if it is 5 minutes greater than the value in the column next to it. It's to compare times to see if a person was late to work, we ...
1
vote
2answers
50 views

conditional formatting excel 2013

Is there a way to highlight a cell (possibly with conditional formatting) if one of the cells to the left of it has data, but it is empty? for instance, A B C D ...
1
vote
1answer
101 views

Conditional formatting from another conditional format in Excel

In Sheet X I have a bunch of cells that are conditionally formatted with a fill color. I want the colors from Sheet X to be dynamically updated to Sheet Y and Sheet Z. That is, if cell X:3:D is ...
1
vote
1answer
701 views

Conditional formatting for entire row based on fixed column

How do I create the following conditonal formatting: If the date in G3 is older than today, turn all of row 3 red So in other words I want my entire row to be formatted based on the value in the ...
1
vote
1answer
626 views

Excel conditional formatting based on a formula including a range containing the current cell

I want to change the background of a cell as long as the running total in that column from start to that cell is less than a limit specified in a different cell. Conceptually, the formula should look ...
1
vote
1answer
748 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 ...
1
vote
1answer
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?
1
vote
3answers
317 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
1answer
123 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 ...
1
vote
1answer
436 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 ...
1
vote
1answer
129 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, ...
1
vote
0answers
21 views

Creating a list from another list's value

How can I populate a cell with a list as a result of a condition from another dropdown list? I have a dropdown list, when I select a value from it I will need to populate the cell beside it with ...
1
vote
1answer
63 views

How to combine data from two sheets and conditionally format rows based on sheet of origin

I have 3 sheets in Excel "Open", "New", "Combine" "Open" Sheet (Old list) Ticket ID | Priority | Department | Status 36009 | 1 | Finance | 01-Open 34781 ...
1
vote
1answer
76 views

Excel 2013 - Problems splitting cell containing two decimal numbers

I need to separate values that look like this and are in one column in an excel spreadsheet. 48.116667, 11.55 I though this would be easy and did this: Select the column, click on (Data Ribbon) - ...
1
vote
0answers
64 views

Excel 2011 conditional formatting, problems w/ adding deleting rows [duplicate]

I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row. The form varies wildly in length. Currently, I am using conditional ...