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

0
votes
1answer
822 views

Conditionally formatting a cell in a pivot table based on a range of cells grouped by a Column Label

Within my pivot table I currently have cells conditionally formatted- Value=1, Green and Value=0, Yellow. I would like to conditionally format based upon all the values within a row label underneath a ...
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 ...
0
votes
2answers
369 views

Highlight row when two columns contain specified values

I have 2 columns "N" and "O" . Both columns can contain "x". If column N has an x and column O is null then highlight the line. This should apply to the entire worksheet. Thanks so much in advance. ...
1
vote
1answer
259 views

Format columns matching drop down value Excel 2003/VBA

I have a drop down in Excel to allow user to select a comparison bank. When a bank is selected for comparison all occurrences of that bank are highlighted in the tables below the drop down. Here is ...
2
votes
4answers
492 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? ...
0
votes
1answer
1k views

Excel 2007 conditional formatting rule using formula to highlight a row based on matching text between columns

I am checking accountability of whether my office is creating source acknowledgement reports "C", recommended whenever a reference document "A" is read, and required whenever an article "B" is ...
1
vote
0answers
59 views

Conditionally generate Excel sheet

I currently have an excel sheet that is used to record daily a bunch of parameters. Currently, I have a folder for each year, containing a folder for each month, inside of which I have an excel file ...
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
0answers
246 views

Excel 2011 Conditional Formatting: compatibility issues

I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed). The purpose is a semi-automatic calendar, where one enters ...
0
votes
3answers
260 views

Excel: How to format each group of data separately

Is it possible to automatically color each row of data, so that the beginning and end of each day is more visible? Do you think I can do that with conditional formatting? Something like the following ...
-1
votes
1answer
966 views

Set an Excel cell's color based on multiple other cells' colors

I have an Excel 2007 spreadsheet for a list of products and a bunch of factors to rate each one on, and I'm using Conditional Formatting to set the color of the cells in the individual attribute ...
1
vote
1answer
2k views

Excel 2007 - Conditional Formatting: Compare 3 columns with text - find unique values

I have a spreadsheet with three columns, each column listing the folder names found on a server. Server1 | Server2 | Server3 --------|---------|--------- A | | A ...
2
votes
1answer
145 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
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 ...
0
votes
2answers
4k views

Setting background colour of cells based on their string length

Suppose I have this column of data Canada Chile China ... How do I set the background colour of each cell if the length of the string in it is greater than say 5? ('Canada' cell would be ...
1
vote
1answer
281 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 ...
2
votes
1answer
11k 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 ...
0
votes
1answer
3k views

How to let Excel 2007 display a certain text as long/soon as a cell is empty? [duplicate]

Possible Duplicate: custom format for cells with nothing in them without using conditional formatting I'd like Excel 2007 to display a certain text like "" as long as a cell is empty. So ...
2
votes
2answers
31k 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 ...
0
votes
1answer
348 views

Conditional Formatting with more than one variable

If ( cell A10 =2 ) AND ( cells C10:c15 through d10:d15 are blank) Then color cells c10:15 through d10:15 red I can do one or the other but can't figure out how to make it meet both criteria prior ...
1
vote
1answer
143 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 ...
3
votes
2answers
4k 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 ...
2
votes
1answer
992 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 ...
3
votes
1answer
2k 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). ...
0
votes
0answers
20 views

How to apply Conditional Formatting to a row of data if a certain cell is blank [duplicate]

Possible Duplicate: Conditional formatting to highlight the whole row Here's the problem I am facing: I want to highlight A1:M1 if L1 is blank, A2:M2 if L2 is blank, A3:M3 if L3 is blank, ...
2
votes
1answer
8k 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 ...
1
vote
1answer
885 views

Excel 2007: finding duplicates ACROSS multiple columns [duplicate]

Possible Duplicate: Excel 2010 conditional formatting: selectively highlighting duplicates First of all, this is basically a cut-and-paste of another question regarding Excel 2010. When I ...
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
1answer
136 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 ...
-1
votes
1answer
172 views

Can someone tell me why this conditional formatting is wrong? Date ranges

I'm just literally doing a 3-color scale like so: Minimum: =($L$3-TODAY())<7 Midpoint: =($L$3-TODAY())<14 Max: =($L$3-TODAY())>14 I thought this would be correct but it won't format ...
1
vote
0answers
3k views

Excel conditional formatting, greater than a year

I am working on a spreadsheet that logs the dates parts were sent out and would like to apply conditional formatting to the dates. I would like if over 3 years ago, if over 2 years ago, if over 1, ...
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 ...
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 ...
1
vote
1answer
752 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 ...
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.
5
votes
2answers
5k 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 ...
0
votes
2answers
3k views

How can I set up conditional formatting to highlight a range only if all its cells are empty?

I am new to conditional formatting and having a hard time. I have 6 columns with 100 rows. What I would like to have happen is to highlight the row in one color if there is no data in it at all. If ...
0
votes
2answers
2k views

Conditional formatting 2 different colors every two rows

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) two lines each. This is the ...
1
vote
2answers
810 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
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 ...
2
votes
1answer
221 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 ...
0
votes
1answer
109 views

How to apply conditional fomatting for a MAX value to a range of cells

I have a table that is five cells wide by twenty high with a sum function at the end (e.g. cel A20). I want to highlight the column that results in the highest SUM. How do I use conditional formatting ...
0
votes
1answer
2k views

Excel INDIRECT function and conditional formatting - highlighting a row

I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...
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 ...
0
votes
2answers
259 views

Restricting symbols allowed in cells of Excel spreadsheet

I need to format some Excel cells to allow currency (decimal point) only to be entered. Some employees completing the form enter a colon (:) instead of a decimal point which then results in an ...
0
votes
2answers
184 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
2answers
258 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 ...
4
votes
3answers
6k 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
1answer
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
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 ...