# 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

22 views

### Conditional formatting if entry is final entry of the day [migrated]

I have a Google Sheet in which I keep track of transactions, kinda like this:
| Date | Funds | Running total |
|---------|---------|---------------|
| 5/23/18 | 10.00 | 10.00 |
| 5/23/...

**1**

vote

**0**answers

57 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 ...

**0**

votes

**0**answers

3 views

### How do I conditionally format text color to match across sheets in Google Sheets? [migrated]

My problem is as follows:
I am creating a schedule for a sports photography company that uses several photographers to shoot team photos at tournaments. There are 2 sheets in this instance; the ...

**2**

votes

**2**answers

28 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

26 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

70 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

30 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

37 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

69 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

150 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

6 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

71 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

24 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

88 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

55 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

29 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

25 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

437 views

### Highlighting duplicate rows based on 2 columns

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

**0**

votes

**2**answers

84 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

47 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

366 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

46 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

52 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

158 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

37 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

445 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

53 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

67 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

143 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

65 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

211 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

63 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

145 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

61 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

106 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

53 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 "...

**0**

votes

**1**answer

72 views

### Conditional formatting upon another cell

I want to enter the text in a cell, but its depend upon another cell value formatting.
example:
In A1 value is "Vaibhav" and if I will make it in bold(Ctrl+B), then automatically the next consecutive ...

**0**

votes

**0**answers

36 views

### Excel: Graphs which appear only conditionally

I have a rather complex data set and the first column is composed of Booleans.
I want to plot data from each row in a separate graph - but only if the first cell in that row is TRUE. Preferably, this ...

**0**

votes

**1**answer

23 views

### Conditional formatting of cell in each row by using macro

I have a excel table consisting of 500+ rows with column headers.
I need help in writing conditional formatting macro such that in a row A2:L2 if any cell value is not equal to cell value M2 then ...

**0**

votes

**0**answers

16 views

### Conditional formatting behaving differently on connected table

In my Excel (2016) sheet I have a Source sheet which has a Table with all the data of a year. From this table I want individual sheets for each month. I don't want to be copying everything over every ...

**0**

votes

**1**answer

181 views

### Use Excel conditional formatting based on cell display, not content of cell formula

In my Excel worksheet, I have a cell containing the following formula:
=IF(COUNT(Y11:AA11)>0,SUM(Y11:AA11),#N/A)
with the goal of a chart later using the display of the cell in a graph (excluding ...

**0**

votes

**1**answer

1k views

### Conditional Formatting when between two values

I am trying to figure out how to conditionally format a row based on the value in one column. The values can go from 0 - 100, I want 3 different conditions.
value < 90 = Formatting Red
value => 90 ...

**1**

vote

**0**answers

28 views

### IF + Conditional Format issue

I am creating a sign in/out system in Excel. I was able to get the sign in and out system to work, however now I need to highlight rows that fit a certain formula.
I have tried this formula:
=IF(...

**1**

vote

**1**answer

115 views

### LibreOffice Calc color-coding cells categorically

I have a spreadsheet of text data; each column has a limited allowable set of string values. I have a second sheet in the file which, for each column in the first sheet, contains each allowed value ...

**0**

votes

**1**answer

49 views

### How to conditional format Color Cell based on Triplicated Text values

I'm trying to color format cells in an Excel 2013 worksheet. I'm particularly interested in highlighting cells with names values that occur more than 2 times (i.e. triplicate names) in the same column....

**0**

votes

**2**answers

79 views

### Whats wrong with my Excel conditional formatting?

I'm trying to mark a column's data with a red background if the values in it are outside of a 15% threshold. For this I'm trying to use the formula:
=(ABS(($D:$D-$E:$E)/$E:$E))>0.15
However, it ...

**1**

vote

**3**answers

139 views

### Microsoft Excel: Conditional number formatting

There is a column with time periods in the hh:mm:ss format. The seconds aren't used. The time period of three hours and two minutes would be 03:02:00. How to conditionally format the cells to get the ...