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
0answers
33 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
78 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
227 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
554 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
230 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
334 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
77 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
333 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
3k 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
1k 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
4k 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
952 views

how to get text instead of TRUE:FALSE in excel

suppose I have a formula in cell C3:=AND(A1=B1) it will give TRUE:FALSE but i need Yes:No instead so how do I format the cell C3 to get so? Thanks! Regards,
0
votes
1answer
127 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
3answers
632 views

Conditional formatting with multiple conditions

I have to set a simple formatting in excel: colour cells if the value is = to another cell. The question is that I would like to colour the cells if the value equal to A1 or B1 or B3 Is it possible ...
0
votes
2answers
69 views

IF statement with multiple criteria and multiple possible results

I have a spreadsheet and I need a formula to give me one of three possible results (good, neutral, bad) based on data from two cells. MTD and YTD on budget would be good, MTD on budget & YTD below ...
0
votes
1answer
1k 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
2answers
40 views

Conditional formatting to mark rows depending on contents

I have an excel sheet that for the forseeable future will remain as a Work In Progress regarding a project. To easily be able to keep track of rows that need some work I would like to create a macro ...
0
votes
4answers
4k views

Excel function determine if a cell is visible

In conditional formatting I want to detect if the row above the current cell is hidden or visible. How can I detect if a cell is visible or not? The only hack I can think of is: Create a column ...
0
votes
2answers
2k 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
320 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
7k 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
2answers
3k 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
1answer
25 views

Excel Conditional Formatting for Date colums

I have 2 columns with dates and I want to apply conditional formatting to all values where the date in one column is bigger than the date in the other column. So, when the dates in "Actual End ...
0
votes
1answer
55 views

How to use conditional formatting to search a specific value in a range in ms excel?

I have values in the range K5:K333. I want the value in cell S5 be searched in the range and the corresponding cells of the range being formatted. I am using conditional formatting's "use a formula ...
0
votes
3answers
63 views

Adding a date to a formula in excel [closed]

=$M2="COMPLETED" I am using this formula to shade a row when COMPLETED is written in column M, but I would prefer the 'date' or 'COMPLETED and the date' but can't seem to work out how to do this. ...
0
votes
1answer
74 views

Combining the ISBLANK and Date function

I have been searching through forums and can not figure out how to succesfully combine the two functions ISBLANK and a date function. What I need to do is use this formula in google sheets for ...
0
votes
2answers
380 views

Insert spaces in excel number sequences

I am trying to format cells so when I type in phone numbers it automatically formats them as follows: - Landline Nos e.g. 02012345678 to appear as 020 1234 5678 Mobile Nos e.g. 07123456789 to appear ...
0
votes
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 ...
0
votes
1answer
714 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
297 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
3k 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
60 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
23k 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
3answers
7k 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
6k 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
241 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
42 views

How to change cell function [not data] through drop down list

For my very first post I may have a slightly complex question. I've had a decent look around, and either excel doesn't have the functionality or I've got my terms mixed up. I want to create a ...
0
votes
1answer
16 views

Excel nested IFs

I'm trying to combine several IF formulas with an IF(AND formula but struggling. I can manage Nested Ifs or an IF(AND formula but can't seem to combine them. I want to say if L2 equals 1,3 or 4 then ...
0
votes
1answer
51 views

Conditional formatting of PowerPoint-table

Related to this question, I wonder if there is any way to apply conditional formatting to a table in PowerPoint, without importing an Excel-table. E.g. to change the background colour of a cell in the ...
0
votes
1answer
16 views

Duplicate and Unique formatting in same column?

Is it possible to apply both a duplicate and a unique format to a column? I know that a value can only be one, but what if I'm applying the unique rule to say, Col 1 and Col 2 (checking for values ...
0
votes
1answer
50 views

Conditional formatting on blank cells in non-blank rows

I'm looking for how to apply conditional formatting to blank cells - but ONLY if the row they are in is not completely blank. For example, I'm making a project tracking sheet, and I want incomplete ...
0
votes
1answer
44 views

Excel formula related to conditional formatting

Column A has 10 numbers expressed as percentages and is conditionally formatted to highlight the top 40%. I want column B to show a "1" next to the corresponding highlighted top 40% of numbers in ...
0
votes
1answer
817 views

how to highlight the cell with the max value

given a range of non adjacent columns (not sure if it matters if they're adjacent) i.e F1:F100,J1:J100,N1:N100 for each row i'd like to highlight the cell with the maximum value. i tried ...
0
votes
1answer
71 views

In MS Excel how do I set the number of decimal places dynamically?

I have a table where I am reporting a range of correlation coefficients which range from -1.0 to +1.0. I want to format them such that if they are plus or minus one or zero, then they are formatted ...
0
votes
1answer
58 views

How to avoid apply to range in copying conditional formatting in excel 2007 [closed]

I want to change the selected cell(A1) colour if its value is greater than other cell(B1) in same row.When i copy this conditional formatting to other multiple cells(A2,A3,A4...) in below rows, it is ...
0
votes
1answer
867 views

Excel auto format cell's font size based on number value?

I want to make cell's number values to be smaller, in font size, with small values i.e. the bigger the cell value is, the bigger is the font size. I can only find Data Bars in Conditional ...
0
votes
1answer
753 views

Custom format to display percentage with plus/minus sign

Suppose I have cell value 0.465 and I want to display it in the spreadsheet in green as +46.5 if it is positive and -46.5 if it is negative. I have applied the following format ...
0
votes
1answer
25 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
26 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
154 views

Highlight Duplicates Not Next To Each Other Using Conditional Formatting

We have a list of parts in Excel in a certain order. For reasons I won't get into, we need to highlight when there are duplicates that aren't next to each other. Currently, I'm using this formula in a ...