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

1
vote
1answer
166 views

A formula to check if the date is older or equal to 60 days and another columns cell is equal to a value

I have tried using conditional formatting and managed to get the first part of the formula to work. =D2:D999<=TODAY()-60 I want to then also check if the value of what is in column G is equal to ...
1
vote
1answer
38 views

Conditional formatting excel conundrum

I have a list of values in excel. I would like to highlight a cell if its more than 1.5 higher or lower than the value before it or after it. Is this possible? Thanks guys!!
1
vote
1answer
79 views

Excel: Different background colors on condition

The problem I have a Excel sheet that contains a status column. Number Status Name ------------------------------------- 1 not implemented feature 1 2 completed ...
1
vote
0answers
25 views

Excel for Mac 2011 - Conditional Format - Look inside formula for sheet reference

I would like to use conditional formatting to locate all cells on a large sheet (Sheet 1) that have a reference to another sheet (Sheet 2) within a formula in a cell on Sheet 1. I was hoping I could ...
1
vote
0answers
43 views

How to search Excel conditional formatting formula with specific text

Sorry I did try to search but could not find a question similar to what I want. My Question: Is there any easy way I could search all conditional formatting that has formula with specific text? I ...
1
vote
0answers
133 views

Conditional Formatting a date/time comparison

The function I'm working on specifically compares & colors a daily recurring time range set in 2 different cells. A specific date in the target cells (produced by a formula) compare to that daily ...
1
vote
0answers
345 views

Recolour a single occurrence of a recurring appointment in Outlook 2010

Brief: Recolour a single occurrence of a recurring appointment. I have the following recurring appointment: Subject: Maths 104 Date: N/A (series) Time: Thursday 12pm Recurring: Weekly (4th March to ...
1
vote
1answer
161 views

Excel, Pasting text with hyperlinks, conditional formatting for doubles

I have a list of names that I paste, individually, from a site into a column of cells in a table. I have conditional formatting to tell me if there are doubles. However, when I copy straight from ...
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 ...
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
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 ...
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 ...
1
vote
1answer
883 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 ...
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, ...
0
votes
3answers
11k views

How to hide number but keep Excel cell background color?

I got a sheet like the below figure. I want to hide all the number and just keep the background color. How can I do it?
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
992 views

Conditional Formatting - Highlight An Entire Row by Comparing Two Cells of a Column

I've dug through the questions on this site and they address both problems I have, but separately. I've been trying to combine the solutions for a couple hours with no success. Basically, I would ...
0
votes
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 ...
0
votes
2answers
489 views

Excel 2010 Conditional Formatting for a range based on “Less Than” and “OR”

How do I use conditional formatting on a range of values such that every third cell should be filled with a particular color if the value entered in that cell is lower than values in any of the three ...
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 ...
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 ...
0
votes
1answer
81 views

Conditional Formatting Cells with Different Values for Rows with the Same Value in Specific Column

I need to conditionally format cells with different values between the same columns, if their value for a specific column is the same. Scenario My spreadsheet is a contacts database, where each row ...
0
votes
1answer
146 views

Excel Conditional Formatting: 3 color scale scoring fuzzy matched data for Windows [duplicate]

This question is posted as a spinoff from here - the post cited is about Mac where as this is about Windows: Conditional Formatting: 3 color scale showing text relevance in Excel for Mac Is ...
0
votes
1answer
912 views

How can conditional formatting be used for duplicate cells on different sheets?

I have set up multiple tabs on excel 2013, I have created a conditional format to highlight box red when duplicate information is entered. However I would like this also to happen on the different ...
0
votes
1answer
39 views

Conditional formatting in Excel 2013

Hi I want use conditional formatting. On this values: everything works, but when i change values (mid and max values are similiar) to: conditional Formatting do not works. What I do bad?
0
votes
1answer
11k views

Conditional formatting to highlight the whole row if a cell is left blank

Could anyone tell me please how to highlight a row if the first cell in that row is missing a value?
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 ...
0
votes
2answers
2k views

Apply strike out text on row

I have a question about Excel 2007 and I'm not sure if its even possible, but if any community can help it's here. I want to strike out all the text for all cells in a row if the text in column A ...
0
votes
1answer
228 views

How do I format each cell in column FOO in Excel if the len() of the cell value is longer then BAR?

If this is the wrong place to ask this let me know. Here is the formula I have right now: =LEN($A$2)>$AB$11 Applies to: =$A$2 That works great for the one cell. I need it to apply to each ...
0
votes
1answer
17 views

Change background color of rows which are present in another column

I have data in the A and B column. B column's data is mostly duplicates of A's data, but not always. For example: A Budapest Prague Paris Bukarest Moscow Rome New York B Budapest Prague Los Angeles ...
0
votes
1answer
16 views

Excel Title Row — Not part of the count when using conditional formatting

I would like to set my Excel document to color every tenth line in the document using conditional formatting -- without counting the header row as row 1. Is there any way to accomplish this?
0
votes
2answers
79 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 ...
0
votes
2answers
2k views

Correct use of the Formula type in Excel Colour Scales

I'm trying to work some trickery in excel where each cell in a row is shaded based on how many have been completed: So the idea is that as more of the columns in the row are ticked the whole row ...
0
votes
2answers
58 views

How to put conditional formatting in a cell from another excel worksheet [closed]

It's hard to describe what I want, I'm not really familiar with Excel condition terms but it is basically just like this: Worksheet= Dr. castro patient consultations A B C D E ...
0
votes
1answer
816 views

How to format cells between two dates with a colour based on a value in vba?

(apologies if this question is difficult to understand, i'm unable to post an image) I've tried finding a solution for this online but haven't had much luck. Ideally, I want to use conditional ...
0
votes
1answer
284 views

Automatically format currency based on adjacent column - Excel

Using Excel and need a little help with a simple formula. I know conditional formatting should do the trick here, however, I need help creating the exact formula for my need. In column A I write the ...
0
votes
1answer
58 views

Is it possible to get array/CSE formulas to work with conditional formatting?

I am trying to get a CSE formula to work with conditonal formatting. When using CSEs with cells, you hit CTRL+SHIFT+ENTER, but it appears that this key combination doesn't register in the conditional ...
0
votes
1answer
67 views

Conditional formatting duplicates for highlighted cells

I would like to conditionally highlight cells in a row. When the items in column B are duplicates then cells in columns B and C should be highlighted. The value 7264 in column B has duplicates so ...
0
votes
3answers
3k views

For Excel how do I create a field that automatically generates a sequential number

How do I create a field that automatically generates a unique number when I enter a new record in a table ? I have a list of numbers in the B column. I want the numbers in column A to automatically ...
0
votes
2answers
699 views

Conditional format cells that are duplicated in every column

I have a table in which every column describes a product and every row is responsible for one attribute of the product. I want to highlight cells which are duplicated in every column. I have for ...
0
votes
1answer
161 views

How do you use conditional formatting in Excel to format based on previous cell information?

I have a document that is created to monitor complaince. I would like to have the following rules: Highlight the cell if it meets a goal - I've figured this out and the formatting works. Highlight ...
0
votes
1answer
1k views

Why am I getting unexplained vertical lines in the center of merged cells?

I am working on a spreadsheet that merges 20 columns into a single row. This row is conditionally formatted to display a data bar, of a proportional length based on a set of values from 0 to 275 that ...
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 ...
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 ...
0
votes
3answers
386 views

CF: Cell STATUS + Cell DATE compared to NOW(DATE) = Colour

If the status in cell $D5 is "AWAITING FEEDBACK" I want to compare the DATE in cell $H5 against TODAYS DATE and CONDITIONAL FORMAT cell $H5 using the data bars formatting (colour to transparent). If ...
0
votes
1answer
36 views

How can I make Excel conditionally highlight cells based on the contents of cells?

I have a few things that I would like to do on Excel: How do you highlight a row [A-U] if only the first cell A has had text entered in it? When you enter text in cell A cells B-U have a yellow ...
0
votes
1answer
72 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 ...
0
votes
0answers
43 views

Change value color in a specific column/row/cell if not equal to another specific column/row/cell

I have column A and column B. Column B's rows contain one of the values A, B, C, or D. The user needs input in column A any change to the value in column B. If there is no change, or the value is the ...
0
votes
2answers
19 views

Excel 2010 Custom Formula / Conditional Formatting to highlight data that is greater than Twice the Value of Original Cell

I am trying to figure out how to indicate cells that are greater than twice the value when compared to a specific cell. For example, a value of .1 compared to .18 would be OK but .1 compared to .2 ...