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
0answers
13 views

Excel 2011 conditional formatting, problems w/ adding deleting rows

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 ...
1
vote
1answer
32 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
29 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!!
0
votes
1answer
40 views

Conditional Formatting for one cell value in a list, another cell blank

Looking for how to do Conditional Formatting for the following rule: If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. ...
0
votes
2answers
24 views

Excel Formating - How do I compare 2 cells and highlight one of them based on the date in 1 Col being further out then the date in the other?

I have a spreadsheet tracking multiple dates for about 150 people. I am having a problem however getting dates in Col I to highlight if they are going to be past the date in Col P. I want Col I Row ...
1
vote
1answer
56 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
13 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 ...
0
votes
2answers
44 views

Selectively find duplicates across columns

Column A has the product ID. There are 102 other columns with other data. Column A will be unique unless some data was changed. In that case, there will be 2 rows with 99% of the columns are ...
1
vote
0answers
30 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 ...
0
votes
2answers
57 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
0answers
54 views

How to use a color coded drop down in Excel across multiple sheets?

I have seen a few examples on how to create a color coded drop down in an excel spreadsheet. An example of what to do can be seen here. ...
0
votes
1answer
150 views

Returning row values based on specific variables across multiple sheets.

I'm not entirely sure how to properly explain this, but here we go... I'm trying to create a single budgeting document that allows me to manage purchasing and reconciliation for multiple projects. I ...
3
votes
2answers
116 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 ...
0
votes
1answer
71 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
3answers
177 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 ...
0
votes
1answer
57 views

Conditional formatting in Excel 2013 for C8=blue and bold if C5>C2

This is part of a problem for college for which I can't find a solution. Q: Use conditional formatting to format, in blue and bold, the value in column 8 for which the value in column 5 is greater ...
0
votes
1answer
21 views

How to suppress repeating values in a manner that takes into account previous conditional formatting? (Google Calendar-like scheduling blocks)

I'm in the process of creating a scheduling template. I'm trying to figure out how I create a conditional formatting formula for suppressing repeating values that takes into account the conditional ...
0
votes
1answer
111 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 ...
2
votes
1answer
38 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 ...
1
vote
2answers
41 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 ...
0
votes
1answer
26 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
2answers
486 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
40 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 ...
-1
votes
1answer
35 views

Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...
0
votes
1answer
377 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
0answers
30 views

How to use Color Bar for String Values in Excel 2010

I like to color the backgrounds of the cells which has similar values. There are huge no. of such values so it is not possible to create condition/rule for each. I am looking for a shortcut. Like this ...
1
vote
1answer
57 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 ...
0
votes
1answer
104 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
0answers
193 views

VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below). Please note that: Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table' The number of columns, ...
0
votes
1answer
45 views

How can I set up this conditional formatting in Excel 2010?

We create sections by highlighting an area in Excel 2010 and clicking ALL BORDERS. We want to set it so that any time you type "REPLA" between columns J and Q, the line that "REPLA" is in will Fill ...
0
votes
1answer
47 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
82 views

How to change a row of cells on excel 2010 depending on different cell data

Can anyone help me with a problem I'm having on excel 2010 please? I am trying to change the colour of part of a row of cells when certain data is input. For example I want cells A13 to G13 to ...
1
vote
1answer
71 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 ...
3
votes
0answers
479 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 ...
0
votes
1answer
87 views

Excel - Using condtional formatting in a count down of the date

So i am using Excel Mac 2008, i want a formula where i enter a date and if the date is less than 5 days from today, it turns bold and red. can anyone help me figure this out? I have a formula that ...
4
votes
1answer
261 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 ...
0
votes
1answer
53 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
0answers
160 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 ...
1
vote
2answers
992 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 ...
6
votes
1answer
2k 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 ...
0
votes
0answers
74 views

Using variables to conditionally format Pivot Table in Excel 2007

I have data in a Pivot Table which I need to conditionally format. How can you do this using one column as a variant to determine the colour of the corresponding cell (e.g. Region and then Month, then ...
0
votes
0answers
24 views

my toggle formula appears to be interfering with my conditional formatting

My toggle formula appears to be interfering with my conditional formatting. This formula { =IF(K805=TRUE, "8 Cmplt", "2 Pending") } yields me a working toggle button but it doesn't turn the ...
0
votes
0answers
14 views

Conditional Formatting for entire ROW based on a cell entry number in a particular column [duplicate]

I am looking for how to have conditional formatting for a row if a certain cell has a certain number in it. If a cell in column J has the number 284 in the cell, then the whole row (cells A - J ) ...
1
vote
1answer
214 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 ...
0
votes
0answers
29 views

Copy the results of conditional formats which use sums to colour cells

I have set up a number of rules in some conditional formatting which results in colouring cells on a sheet of about 2,500 rows. I need to be able to copy the resulting formatting colours, to issue ...
1
vote
0answers
89 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 ...
2
votes
1answer
12k 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 ...
0
votes
0answers
49 views

Use the formatting from data table cells for drop down table results

I am setting up a risk ranking table and risk analysis spreadsheet in Excel 2010 The user selects from two drop down boxes (liklihood and consequence) and it gives the corrosponding result. I have ...
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 ...
0
votes
0answers
20 views

How to conditionally format cells in excel based on whether contents is a formula or text/number [duplicate]

I'd like to conditionally format cells in Excel based on whether they contain a formula or not. If it's a formula I don't want formatting to change, if somebody overwrites contents of the cell with ...