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
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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
1answer
25 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
22 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
22 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
22 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
63 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
5 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
34 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
63 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
22 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
42 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
32 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
27 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
14 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
28 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
261 views

Highlighting duplicate rows based on 2 columns

I have the following data: Title | Volume | Price --------------------------------------------------------------- Girl Friends Omnibus ...
0
votes
2answers
80 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
35 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
136 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
38 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 ...
1
vote
1answer
49 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
141 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
36 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
234 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
44 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
39 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
67 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
58 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
111 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
53 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
68 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
56 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
70 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
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
1answer
67 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
0answers
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
1answer
19 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
0answers
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
1answer
118 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
1answer
517 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
0answers
27 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
1answer
86 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
1answer
34 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
2answers
44 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
3answers
123 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 ...
0
votes
1answer
57 views

Conditional formatting on dates in Excel 2013 [closed]

I want to use conditional formatting on dates. I want the formula to underline only Saturdays and Sundays, and to make Monday number 0 in days of a week (Ex. Monday=0, Tuesday=1, Wednesday=2, etc). I ...
0
votes
0answers
47 views

Excel conditional formatting using formulas

I have two conditions that I would like to format. The conditional formatting commands will go in a macro that will be used on a weekly report. The number of rows in the report will vary from week to ...
0
votes
1answer
38 views

Conditional formatting — but seems to be outside the scope of types provided

Version: Office 365 Is it possible to set the background color of a cell based on the DATE value in another cell? It seems like Conditional Formatting should handle this, but the choices under "...
1
vote
3answers
2k views

Conditional Formatting in Excel with Formula Current Cell

What to put into formula to determine conditional formatting to reference current cell? E.g. I want to make conditional formatting for if cell contains error (#N/A) and use the same rule for the ...
1
vote
2answers
69 views

How to copy conditional formulas across sections of a worksheet?

I have data laid out within mini tables within a singular worksheet. See picture I need to conditionally format the whole row (within the minitable) based on a cell value within the row. For example,...