Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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
0answers
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
2answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
865 views

Highlighting duplicate rows based on 2 columns

I have the following data: Title | Volume | Price --------------------------------------------------------------- Girl Friends Omnibus ...
0
votes
2answers
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
1answer
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
3answers
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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 "...