# Questions tagged [conditional-formatting]

Spreadsheet feature that allows automatically adding color, text styles, etc. to certain cells or ranges of cells based on the data workbook

**0**

votes

**0**answers

2 views

### Cannot lookup value and create conditional formatting in excel 2010

I have one worksheet which has in the A column product sku and at C D E columns supplier names.
Each supplier has its own worksheet which has again product sku price and availability.(suppliers ...

**0**

votes

**1**answer

28 views

### Having trouble comparing multiple columns and rows in different worksheets in excel

I have limited knowledge of formulas in excel and would really appreciate help with this question:
I have two worksheets: Worksheet1 and Worksheet2. Worksheet A1 shows a list of all the samples that ...

**0**

votes

**1**answer

25 views

### Is there a way to colour rows that have an idetical value?

Is there a way to automatically colour rows the same colour if they have a field (like ID) that is the same?
So something like this

**0**

votes

**2**answers

53 views

### I've searched many post but can't find my answer

I've searched for help before posting and read many post on how to turn conditional formatting on/off or disable it within a file.
Is there any way to remove the automatic conditional formatting on ...

**0**

votes

**2**answers

134 views

### Conditional formatting on 4th entry?

I know how to change the cell color for a duplicated entry, but how/can I change the color on every 4th entry? Value will be an unknown number & letter combo, wanting to highlight every 4th time ...

**1**

vote

**1**answer

31 views

### Excel conditional formatting: formula blanks treated inconsistently?

I am adding some functionality to a spreadsheet I've used for ages and it seems that conditional formatting behaves inconsistently with empties and formula blanks. Please see snippets below, followed ...

**0**

votes

**0**answers

20 views

### Cell to change color based on multiple conditions and have both conditions work

I am creating a traffic light in excel. I want the following things to happen based on value of a different cell and on a range of cells. For example if =(F8:F34 <>"") then I want the cell to be ...

**0**

votes

**0**answers

12 views

### WORD header using conditional field code ( e.g. with IF & StyleRef)

My Word document has the headings with numbering and numbering begins with Chapter 1, 2,3 omitting ToC(Table of Content), i.e.:
Table of Content
1 Chapter One
1.1 Subchapter one
...
2 Chapter Two
...

**0**

votes

**1**answer

37 views

### Display email as plain-text/HTML depending on sender?

For security reasons, I use the "Read all standard mail in plain text" option by default:
And I then have to change to the HTML display on incoming emails (which are first displayed as plain text ...

**2**

votes

**1**answer

28 views

### Format chart colours based on series values

Is it possible to format the colours of a bar chart with a single series based on their values, i.e. anything over 50 would be green, anything below would be red?
What I currently have to do is a ...

**0**

votes

**1**answer

38 views

### Copying Conditional Formatting from Another set of Cells

I have a matrix in which each cell is two numbers concatenated together. As a result, I cannot do a conditional formatting heat map on the matrix as excel doesn't have a range of numbers to read ...

**1**

vote

**2**answers

90 views

### Conditional formatting based on date difference

I need help with making the row or at least the cell turn red when it has been >20 days since the date that was entered in the cell.
For instance: I issue an item to John on 10/01/2018 and so I place ...

**0**

votes

**1**answer

55 views

### conditional formating - multicolor text according to different value in same cell

So I am preparing a report of sorts in Excel and was wondering if I can color text in a certain column according to what values are in it using conditional formatting? To be precise there will be two ...

**1**

vote

**0**answers

61 views

### Excel: why do “remove duplicates” and “conditionally highlight duplicates” give different results?

Obviously these tasks do different things! But I am using them to find out if I have duplicates :)
In excel I have a column which is a concatenation of all of the other columns.
(The formula is ...

**2**

votes

**2**answers

82 views

### LibreOffice Calc: conditional formatting based of column / cell value

Unfortunately I cannot grasp how the conditional formatting works. I have a sheet like that:
I have defined 2 cell styles "Low" and "High" and I want cells in columns A-E to have one of these styles ...

**0**

votes

**0**answers

27 views

### Conditional Formatting, values equal to those in a row above

I have this multi row table:
https://drive.google.com/file/d/1Hx0NEhgGcgEZKad7rullXTiq-bZOCCHn/view?usp=sharing
The first row pulls a value from elsewhere.
The middle group of rows are manually ...

**0**

votes

**1**answer

177 views

### Copying Relative Conditional Formatting

I have a sheet that color a number of cells in a group based on one cell. I need many copies of this group, and I often need to delete and re-add them.
How can I copy and paste conditional formatting ...

**1**

vote

**1**answer

43 views

### Can conditional formatting distinguish values and formulas?

I'm having an Excel sheet, mentioning the status of a task, with following columns:
Task | ID | First answer date | Workaround date | Solved date | Scheduled date | Still_Open
The column Still_Open ...

**0**

votes

**0**answers

57 views

### Excel 2010 conditional Formatting for multiple conditions

Looking to understand how I can use conditional formatting to look at 2 columns of data, say server name and environment. I am looking for duplicate values (where the same server name shows up in the ...

**0**

votes

**1**answer

222 views

### How can I modify the “Applies To” property of a Cell's Conditional Formatting rule using VBA?

I'm attempting to use VBA to create a conditional formatting rule and apply it to multiple cells.
I've attempted this is by creating the rules for one cell only and then editing the appliesto ...

**0**

votes

**1**answer

299 views

### How to color only numbers and special characters in a Microsoft Excel cell

Is it possible to color only numbers and special characters of a cell (or column) by conditional formatting or some other similar method?
I have created a book in Excel to organize my passwords (or ...

**0**

votes

**1**answer

8 views

### LiberOffice Calc apply style with only specifc attributes

Consider this simple time tracking spreadsheet:
I figured out how to use conditional format to apply a selected style to a region, in this case I use "Accent" for Fridays and Saturdays, and this ...

**-2**

votes

**1**answer

35 views

### Condition Check in a Excel 2007

Cell A1=1, A2=1, A3=A1*A2
When I change A1 Value and if it gives A3>previous value I would like to store the A1=A4
here is explained with Image
Cell A1=1, A2=1, A3=A1*A2
When I change A1 Value and ...

**1**

vote

**1**answer

72 views

### How do I conditionally format all rows in a table, to display a different colour based on a cells value

I have developed a table (as seen below) which is designed to show a persons duties based on priority.
If a person clicks the toggle on/off button, this will toggle colours on the rows of the table, ...

**0**

votes

**1**answer

26 views

### Conditional formatting using OR() ignores one of the arguments

I'm trying to colour the data in one column based on data in another column.
What is wrong with the following formula?
=OR($D1 = "TEXT 1", SEARCH("TEXT 2", $D1) > 0)
What I would like to do here ...

**0**

votes

**0**answers

116 views

### Apply conditional formatting to cells containing “#N/A” in a large set

I want to create one conditional formatting rule for a large cell range that impacts individual cells in that range that contain #N/A — the result of the =NA() function.
This is almost covered here: ...

**0**

votes

**0**answers

101 views

### Prevent breaking conditional formatting when moving cells

This question is a clarified subset of Prevent breaking formulas/formatting by moving cells in locked worksheet, which hasn't been solved yet.
Imagine a simple Excel game:
| A | B |
--------...

**0**

votes

**1**answer

31 views

### Excel, Return a color depending on two other cells text

I need to do an analysis in Excel and I would like to color a cell depending on the text of two other cells. I have to do it for a quite big table, therefore I need a way to not do it manually for ...

**0**

votes

**1**answer

44 views

### Apple Numbers - Conditional formatting with equation

I want to color a cell green if it’s ≤ A1 × 2.
I can do this with a conditional formatting rule in Google Sheets, but conditional formatting in Numbers seems not to support equations, only ...

**0**

votes

**1**answer

29 views

### Fill color the cells of a row between cells containg two specified values

On almost every row of a 100+ row worksheet I have a 1 and a 2.
I would like to automatically shade or fill in color all the cells between the 1 and the 2 for each row, but only when there is both a ...

**3**

votes

**2**answers

865 views

### Highlighting duplicate rows based on 2 columns

I have the following data:
Title | Volume | Price
---------------------------------------------------------------
Girl Friends Omnibus ...

**0**

votes

**2**answers

86 views

### How to identify the original cell location that contains the Max information that my formula gives me?

What I am trying to accomplish is to Identify the Max of B1:B60, B60:B120, B120:B180 and so on throughout the entire column. I would also like to identify the location of those cells, and (ideally) ...

**0**

votes

**1**answer

51 views

### Excel. Data Bar Fill background Part of bar

Is there a way to in Excel 2016 to fill the background part of a data bar. not the progress bit the other part so for 25% 1/4 will be red and the other 3/4 will be green.
OR is there a way to make ...

**3**

votes

**3**answers

658 views

### How would I use Excel's conditional formatting to highlight values closer to 0 between two columns if there are both positive and negative values?

My goal is to fill or highlight the closest number to 0 per each row out of Column A and Column B like I did manually here:
Is it possible to use a formula within conditional formatting and create a ...

**0**

votes

**2**answers

49 views

### Conditional hightlighting based on a 'set' amount above the values in another table

My Excel formula skills are pretty basic and even worse when it comes to conditional formatting. Essentially the following image shows my mileage report which calculates miles taken for each route ...

**2**

votes

**1**answer

54 views

### References in color-scale conditional formatting formulae for ranges

I'm using Libreoffice Calc (v6.1b).
Suppose I have numeric data in sheet column, A and I'm applying conditional formatting to sheet column B. I want each cell of B to have a color on a scale ...

**0**

votes

**2**answers

165 views

### Change the formatting of a cell depending on the value of that cell and another cell

EDIT:
Okay. Thanks to BruceWayne, I have made progress.
However, the formula I ended up with:
=AND($C3="Y",OR($G3<=0.5,$H3<=0.5,$I3<=0.5,$J3<=0.5,$K3<=0.5,$L3<=0.5,$M3<=0.5,$...

**0**

votes

**1**answer

38 views

### Microsoft Excel cell coloring using values of other cells

I'm trying to color a cell using values of other cells, with RGB.
For example : Colour cell A1 with the color R = A3, G = A5-B5, B = 23
Any way of doing that on Excel 2010?

**3**

votes

**2**answers

786 views

### Conditional Formatting: Min Value Across Multiple Columns in Excel

I have three columns--Order, Buy, and Craft--and want to identify the minimum value for the row. In the image below, I identify the value in an additional column. I want to avoid the need for the ...

**1**

vote

**1**answer

78 views

### Conditional Formatting using average function in Google Sheets/Excel

I am trying to figure out how to conditionally format a particular cell depending on the average value of a number of other cells. So I've tried a variety of solutions all either ERROR-ing or not ...

**0**

votes

**1**answer

85 views

### Excel conditional formatting based on absolute numbers

I am unable to get Excel conditional formatting working based on a percentage from 0 to 100. It seems to format based on the minimum and maximum number in the selection.
I have 3 separate rules with ...

**0**

votes

**0**answers

232 views

### How to see all not answered emails from my colleagues in Outlook 2016?

I look for a solution to set a filter in Outlook's Folder Sent Items to see all not answered emails from my colleagues.
Example:
I send out 100 emails.
Some of the mails have one To person,
some ...

**0**

votes

**2**answers

74 views

### How do to underline rows in excel based on unique data?

I'm trying to automatically underline certain rows based on unique project IDs in column 1. Please see example table attached. Each Project ID may have different number of rows associated each time ...

**1**

vote

**2**answers

368 views

### How to highlight blank cells in a row only when both adjacent cells in the row are blank?

I'm looking at two columns and if a row has blank cells in both columns, I want to highlight both blank cells (but nothing would be highlighted unless both are empty). How can I do that?

**2**

votes

**1**answer

26 views

### Conditional Formatting - Excel 2007

This is driving me nuts. I have a very simple set of rules I wish to use. The cells show an increase or decrease as a percentage of a previous result. I want:
If a percentage is above or equal to 1 ...

**0**

votes

**1**answer

77 views

### Conditional format cell based on cell used in formula

I have cells that I want to highlight based on the cell used in the formula of the cell. Basically I want Excel to look at the formula, and if it is using "$G$1" color it blue, and if $G$1 is replaced ...

**0**

votes

**2**answers

180 views

### Excel - Don't make a blank cell if condition returns false

I have this formula =IF(Sheet1!C2="x", Sheet1!B2,"") which function is to match if the cell from Sheet1 in column C is same as the character of x, if true then get the value of Sheet1 in column B and ...

**0**

votes

**1**answer

70 views

### How to format a cell to auto-highlight a date that is in the past

I am trying to find a way to auto-highlight a cell in a specific color if the date entered in the cell is in the past compared to today's date.
If today's date is 4/26 and I enter 4/23 into the cell,...

**0**

votes

**0**answers

126 views

### Why is Excel Number Format still showing decimal place despite my Conditional Formula?

I'm trying to format my table such that only numbers with a decimal value greater than 0.1 show up with a decimal place. So for e.g. for the number 2.00625, I only want this to show up as "2" not "2.0"...

**1**

vote

**1**answer

58 views

### Change color for specific number of cells by value set in other cell

I have an excel sheet with data of planned and pending projects. In column "I" it states number of weeks required for completion of the project. Each row has separate projects listed. Column "J" to "...