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

13
votes
2answers
5k 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 ...
7
votes
2answers
10k views

How to color rows based on cell value in Open/Libre Office

How do you automatically set the background color of an entire row based on the value of a specific column in that row in Open/Libre Office? There are similar questions for Excel, but this doesn't ...
6
votes
1answer
4k views

How to conditionally create a hyperlink based on value of a cell

ColA Col B ColC Project A A.pdf A.pdf Project B No Link I have a list of project records. One column (e.g., B) ...
6
votes
2answers
3k views

How do I keep Conditional Formatting formulas and ranges from automatically changing?

I've found that Conditional Formatting formulas and ranges will automatically adjust when you copy, delete, or move data around in a spreadsheet. While this is a nice idea, it tends to break things ...
5
votes
2answers
3k 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 ...
5
votes
1answer
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 ...
5
votes
3answers
14k 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.
5
votes
1answer
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 ...
5
votes
1answer
18k 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 ...
4
votes
2answers
7k views

Alternate grid background color in excel when a value of a single column changes?

I need a formula for conditional formatting to make an Excel 2010 spreadsheet alternate highlighting when a single column changes. This question, "How can I alternate grid background color in excel ...
4
votes
2answers
3k 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.
4
votes
2answers
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 ...
4
votes
3answers
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 ...
4
votes
1answer
272 views

Excel: Dual graded color scales

Is it possible to do conditional formating for two graded color scales over the same cells? For example I wish to conditionally format a cell such that its color is: Green to Blue graded scale for ...
4
votes
1answer
322 views

Excel conditional formatting fragmentation

Often, I create a sheet with conditional formatting, and set the cell ranges so that the conditional formatting rules are only applied once to a range of cells, e.g. Make $A$1:$A$30 red and Make ...
4
votes
1answer
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
6answers
21k views

Prevents cells from printing in Excel

Is it possible to prevent the contents of specific cells (or entire row or column) from printing in Excel? I need to maintain the cell size. I've been setting the text color to white before printing, ...
3
votes
2answers
150 views

Highlighting Cells in Excel based on the Value Associated with the Cell

I have two sheets: Users in their respective groups and A compilation of those same users with an expiration date. I'd like to highlight any cell in the the first sheet if their respective date ...
3
votes
4answers
7k 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)?
3
votes
1answer
11k 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?
3
votes
2answers
1k views

How can I format data bars based on value in Excel 2010?

I have a dataset containing values from 0 to 584. I would like to illustrate this using data bars, but I would like the databars to be green when the number is greater than 150, and red when the ...
3
votes
2answers
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 ...
3
votes
2answers
2k 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 ...
3
votes
1answer
72 views

Formatting Entire Row with Multiple Rules

I would like to change the formatting (specifically text color) for an entire row based on which selection is chosen from a drop down list in Column C. Example: If C2 equals 'XX'(one of the ...
3
votes
1answer
132 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 ...
3
votes
1answer
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 ...
3
votes
0answers
536 views

Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table

One of our users uses pivot tables a lot. She often called me about Excel crashing from time to time without being able to reproduce the problem. Today we have found a way to reproduce the crash every ...
2
votes
2answers
3k 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 ...
2
votes
1answer
215 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 ...
2
votes
1answer
8k views

Formatting a column based on another columns cell TEXT (not value) in Excel [duplicate]

Possible Duplicate: Excel 2010 conditional formatting: selectively highlighting duplicates I have dates that are running off a formula in that column based on information it's collecting ...
2
votes
3answers
4k views

Is it possible to save conditional formatting rules for reuse in a new workbook?

I want to make some rules that I can haves saved that I can easily apply to new workbooks as needed. It's a pain doing it how I currently do where I'm always having to go back through and recreate ...
2
votes
2answers
26k views

How to change row color based on a single cell's value? [duplicate]

Possible Duplicate: Conditional formatting of TRUE / FALSE values in an Excel 2010 range I have a spreadsheet where I have cell within a row that will contain specific text via data ...
2
votes
1answer
14k views

Excel Conditional Formatting if one column equal to another

This should be the simplest example of conditional formatting but I can't figure it out. I havave two columns seperated by several dozen other columns ('C'-original data, 'BO'- calculated value) and I ...
2
votes
3answers
865 views

How to format a date field based on whether the date has passed?

I am trying to create an Excel spreadsheet where, when I input a date: if that date is within 30 days it will go yellow, if the date has already gone then it goes red, and if the date is more than ...
2
votes
4answers
453 views

Is it possible to have a conditional formatting cell “visually cycle” through all the formats that evaluated true?

Like the title says, "In Excel, when a cell has multiple conditional formatting rules that evaluate true, is it possible to have the cell "visually cycle" through all the formats that evaluated true? ...
2
votes
1answer
7k 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 ...
2
votes
1answer
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.
2
votes
1answer
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
2answers
52 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
375 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
102 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
142 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
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 ...
2
votes
1answer
623 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
4k 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 ...
2
votes
1answer
169 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
3k 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
772 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
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). ...
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 ...