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

Filter by
Sorted by
Tagged with
0
votes
2answers
19 views

Conditinal Formatting to highlight the first 5 similar cells with a specific text (not the TOP 5)

Column A of my spreadsheet has the following data with only values of A, B, C, D and E (shown below). There are more columns that I like to sort with, and would like the first column to highlight the ...
0
votes
0answers
16 views

Macro validation and conditional check

i have below excel where i want to do data validation for ColumnName1 ColumnName2 ColumnName3 & ColumnName4 and as well check the condition if ColumnName6 = ColumnName7 && ColumnName5 = ...
0
votes
1answer
28 views

#VALUE! error using excel 2016 nested IF statements

I'm unable to perform a simple nested IF statement on this data, the conditional seems perfect to me so it must be a formatting error or something else. I'm new to excel so I could be wrong. This is ...
0
votes
1answer
31 views

Conditional Formatting in cell based on cell value

i am trying below formula to get value of column B all cells ,before hyphen and want to check if before hyphen character len is 8 make it green else red but not working as expected i am using ...
0
votes
1answer
25 views

compare values in excel and highlight the leading number in B1

how do i compare column A which has repeats data against column B which has numbers and highlight the leading number. since the data has no patterns, not quiet getting it, Please help.
0
votes
0answers
19 views

Conditional format against another cell date

I am trying to set conditional format is a cell is blank and today is 1 week later than the value of another cell in that row. I can set this up... but for some reason I can't set it up for the entire ...
0
votes
0answers
19 views

Excel - automatically updating cell reference when applying conditional formatting to range

My question concerns conditional formatting in Excel. Here is a summary of my situation: I have conditional formatting set up for a particular row in Sheet A. The formatting formula checks whether ...
0
votes
1answer
28 views

Highlight a cell based on adjacent value only if it is greater than plus or minus 30 difference

I have a row of 20 numbers and am trying to create a rule that would highlight any cell that pluses up by 30 or more; or decreases by 30 or more compared to the adjacent cells value. Highlight based ...
1
vote
1answer
19 views

Excel Formatting for Symbols

Can someone please explain how to do this: I have two columns (A&B). Column A shows days of the week, while column B shows the pass or fail symbols for each day (see attached). How can i formulate ...
0
votes
0answers
5 views

Conditional Formatting based on the result of a formula, not the in cell formula

I am trying to identify duplicated results in a cell using conditional formatting. However, the conditional formatting is not working as it is currently evaluating the formula in the cell not the ...
1
vote
1answer
25 views

Condition format color cells until sum equal to another cell

I have an Excel file and I need to color the cells in a row until the sum of them reach the number of the selected cell. But if the sum on the cell is only partially covered that cell needs to be ...
0
votes
2answers
34 views

Why is this excel conditional formatting rule removing the cell gridlines?

See what's happening to the cells gridlines (or border?): Here is the rule: This is the rule that is activating it, and it doesn't make sense to me because the fill color is 'no color'. I could see ...
0
votes
1answer
32 views

Hiding #DIV/0! in cells with conditional formatting

I have a cell with conditional formatting and this formula: =IFERROR((F31-E31)/E31,"") That works fine and replaces #DIV/0! with "" when E31 is blank. However, when that condition ...
0
votes
1answer
30 views

MS Excel How to Hide or Change Color of text in a cell with no value

I created a multi-page spreadsheet file originally in LibreOffice Calc (herein after "Calc") and I am now working with it using Microsoft Excel. This is a tool I use to create a week-based ...
1
vote
1answer
19 views

How do I highlight cells in column A that match text in column B?

I'm looking for duplicates. I am trying to highlight all the cells in column A that match text in column B. Cells in column A can be repeated, but B will always have unique text in each cell.
0
votes
1answer
35 views

How do i make different words (in column A1, A25, A37) automatically show a value (in column B1, B25, B37)

Can someone please explain how to do this with different words: I have two columns (A&B) and about 40 rows in excel. I want to put in different words, say - Paper in A1, Chair in A2, Glass in A3,...
0
votes
2answers
18 views

How do i make a word (in column A1) automatically show a value (in column B1)

Can someone please explain how to do the following: I have two columns (A&B) in excel. If i type a word in column A1 - say Paper, i want to have a value show automatically in column B1 - say 25. ...
0
votes
1answer
30 views

How do i make a word (in column A) automatically show a corresponding value (in column B)

Can someone please explain how i can make a word (typed in column A1) automatically show a corresponding value (in the next column B1), ensuring that any line this word is typed on, in the first ...
1
vote
1answer
25 views

How do I highlight duplicate cells across 3 columns for multiple rows?

I have a score sheet that is used to track points for trivia games. Each round has different point values that can be wagered, but you can only use each point value once per round. I would like to ...
0
votes
2answers
61 views

Specifying Today's Tasks in Excel in a seperate column, for seperate products and separate clients

I have a list of various clients of which each client has some of the 4 products we provide a monthly service for. But each product has a different date on which we have to perform the services for ...
1
vote
1answer
47 views

Conditional Formatting - Looking for cells not including two particular characters followed by two numbers

Using Excel 2013 I'm looking to apply a conditional formatting rule to all cells in a range of a column that do not contain SD followed by two numbers, so an example would be SD01 or SD32. The column ...
0
votes
2answers
34 views

Conditional formatting in Excel not working on cell content added dynamically by Microsoft Flow

I have set up a Flow to add content to a table in an Excel spreadsheet once a user makes a form submission. I have applied conditional formatting to a column of this table (change fill colour ...
0
votes
2answers
39 views

Excel highlight cell (text) that equals one of multiple other cells

I want to format cells $C$2:$C$32 if their value (text) is equal to not one other specific cell but one out of multiple cells, let's say $C$35:$C$42. Additionally blank cells should remain untouched. ...
0
votes
0answers
25 views

Excel: Power Query >Table resizing to fit results > Havoc with conditional formatting

Hello and thank you for your time. Excel in Office 365 Version 1904 In a nutshell: Power Query (PQ) pulls a lot of data into a hidden table. Other PQs reference this data to pull what we need for ...
0
votes
2answers
53 views

How to hide formula result until data is entered in at least 5 of the 7 cells

I have a question. Is there a way I can hide the formula result in C10 until data is entered in at least 5 of the 7 cells in column C? Please see screenshot Thanks so much for your help.
0
votes
1answer
30 views

Conditional formatting based on value of adjacent cell

enter image description here I have a bunch of information that I am trying to highlight based on the value of the information in the cell to the right of the current cell. I want it to be highlighted ...
0
votes
1answer
29 views

Excel Highlight Cells Greater than

I am doing a price comparison of various items with last year and this year. so in column F i list current price and Column I with previous price. I want to highlight the cells which has higher price ...
0
votes
1answer
27 views

Conditional Formatting one column of date/time data compared to another colum date/time data 4 hour breach and 1 hour breach

I'd like to conditionally format one column's date/time cell data if the time is over one hour after the date/time cell data on the same row in the previous column by making it red and bold. I've ...
0
votes
0answers
13 views

How to conditionally format an entire column based on the value of the first cell of the column?

I am trying to manage a task list across the year and track it via conditional formatting. The rule for the colour is that if the first cell of the column is equal to or less than today then it should ...
0
votes
0answers
11 views

Keep most recent formatting if conditional formatting stop? (MS Excel 2016)

I appreciate this is a very specific and possible un-resolvable issue, so thanks in advance for any help. I have a spreadsheet which records work done in each month of the year, which then colours a ...
0
votes
1answer
13 views

Excel on Mac Conditional Formatting - Exceptions

I am having some trouble with conditional formatting on the mac. I have two columns of numbers that when multiplied together give a product in a third column. As the third column relates to a risk ...
0
votes
1answer
30 views

Conditional formatting based on cell reference

How can I use conditional formatting to highlight a cell based on an entered cell reference? For eg, If I enter A1, cell A1 must be highlighted. Thank you in advance!
0
votes
1answer
32 views

Conditional format if column contains value and those rows contain another value

I am looking for a way to conditional format (Highlight) cells in a column using 2 conditions: If Cell value is present in column A If the value in the corresponding "B" cell contain a ...
1
vote
2answers
17 views

Conditional format range of cells based on one cell matching another cell

Attached image for clarity (see below). I've got a range of cells in need of conditional formatting. These cells represent our potential incoming weekly orders (cells E20:BA32). The first value in ...
-1
votes
1answer
22 views

Excel Conditional formatting to highlight other cell based on another cells text. Specifically a letter tied to a string of numbers

I have a cell with a string of numbers like this: 11254S987. Other subsequent cells may have a deferent letter mixed in the string of numbers. I want to highlight other cells based on the letter "...
0
votes
1answer
32 views

Conditional formatting fill pattern

I have a query around the auto-population or conditionally formatted cells. Example below: As it stands, the amount column J has the formula =IF(ISBLANK(H9)+ISBLANK(I9)=2,"",H9-I9). The ...
0
votes
0answers
21 views

Match color of color-scale conditionally formatted cell in another cell

I have a spreadsheet with product sales % growth by territory. I have used a color scale conditional formatting to highlight year-over-year territory growth under and over performers by product line. ...
0
votes
1answer
15 views

Apply conditional formatting on different column as the column with the conditional formula

I have an excel table that looks like this (but bigger). If the values in the 2nd, 4th and 6th column are bigger than 0.25, I want the value in the previous column to be red with conditional ...
1
vote
2answers
57 views

Conditional formatting only values in range in Excel

I have these values in A1:C16 in Excel: A B C NA NA NA 3,18E-04 NA NA 3,75E-03 1,03E-10 NA 5,67E+01 7,95E+02 9,61E-16 9,25E-01 9,85E-02 2,04E-01 7,80E-02 1,10E-03 3,04E-01 5,29E-60 1,09E-144 1,...
0
votes
0answers
20 views

Apply conditional formatting data bars to different cells in Excel

I have two columns in my Excel sheet. In the first column I have a task description (text) and in the second column I have the amount of time I would like to spend on that specific task (number). I ...
1
vote
1answer
62 views

Multiple Conditional formatting to highlight a third cell when two cells match

I wanted to highlight a third cell when a first cell matches with a second cell in a list. I used this formula which worked =COUNTIF(V5,$E$5:$E$310) with V5 being the first cell and e5 to e310 being ...
0
votes
1answer
12 views

How to drag conditional formatting (only) across columns using relative reference values

In Excel 2016, I have multiple columns of data, with 2 reference cells above each setting upper/lower limits. I want to highlight all cells in all columns which are not within their respective limit ...
1
vote
1answer
52 views

formatting a number as text

I would like to display the number 1 as low, 2 as medium, and 3 as high, but retain the underlying numerical values. I know how to do this with 0's using custom formats, but can it be done with other ...
0
votes
1answer
26 views

Excel conditional formatting to compare cell values within a row

I have a data table with chronological weeks on the x axis and failure rates for different defect types on the Y axis. I want to highlight all cells where the rate is say .005% higher than its ...
0
votes
1answer
32 views

VLOOKUP Syntax for Conditional Formatting Rule

I'm writing a conditional formatting rule that formats a cell if a VLOOKUP formula returns a value > 0. I usually write out the formula in a cell first to ensure it is syntactically correct. In ...
0
votes
1answer
25 views

Conditional Formatting for multiple cells and ranges in excel

Thank you for taking the time to read my post Here is what I'm trying to accomplish: I have a list of people and some of these people may be on PTO on some days. I am trying to make a conditional ...
0
votes
2answers
765 views

Excel Conditional Formatting if another column contains data

So I have a worksheet which has three date columns, Column B is received date Column D is due date Column F is response date Column D uses the formula =WORKDAY(Bx,$S$1) where S1 just says 10, ...
0
votes
1answer
50 views

EXCEL - How can I use conditional formatting to color code if this week's value has increased by more than 5% from the previous week's value?

I'm tracking the increase or decrease of the percentage total of risks that are classified as being caused by something specific (the Business, IT, legal, Organisation, Security, etc) from report to ...
0
votes
0answers
24 views

Conditional Formatting to combine multiple entries / dates

I am hoping that someone may be able to assist. I am trying to modify a template to use as a resource planner. I am able to create a chart as below with the individual tasks allocated to resources, ...
0
votes
1answer
24 views

Excel 2013 - Highlight duplicate dates after certain number of instances

I'm working on a spreadsheet that will have a column for dates to be entered (column A, named range "in_date"). Elsewhere on the sheet, there will be a cell with the maximum number of ...

1
2 3 4 5
14