All Questions
161
questions
-1
votes
1
answer
38
views
How to count cells that are within specified tolerance with Excel?
I am trying to count the number of cells that are within a certain tolerance using =COUNTIF(). The +/- tolerances are in different columns and I need to apply this formula to multiple rows that have ...
- 1
0
votes
0
answers
50
views
How to highlight cells based on my defined pattern
Experts, Please help this excel newbie
Admin Developer Subscribe
Contributor Product Owner Write
Viewer Stakeholder Create
Test engineer View
Viewer ...
- 1
0
votes
1
answer
38
views
Excel Conditional Formatting Cells in a row
I have an excel spreadsheet organizing material orders, I have 2 columns "Date Expected" and "Date Delivered" I have 1 row functioning the way that I want it to which is if "...
- 3
2
votes
1
answer
38
views
Can I make a conditional design based on other cells (Excel)?
I'm trying to make this by Excel rules:
That any cell (in column B) that is near (beside) "1" (in A) will be red, and any cell near (beside) "2" will be green.
Is there a possible ...
- 141
0
votes
1
answer
31
views
How to use conditional formatting based on a different column?
Looking to format a column background color using conditional formatting based on the integer value from a different column. Where or how is the second column referenced?
Bing AI, copilot, says:
...
- 5
0
votes
1
answer
50
views
How to use conditional formatting on a specific formula added?
I want to add a conditional formatting to a cell. In that cell I have a formula that provides 2 dates. The dates in the cell look like this 01/12/2024 and 01/24/2024.
Originally when I had 1 date in ...
1
vote
1
answer
70
views
Coloring cells across multiple excel sheets in an xls file based on a condition
I am new to excel. I have an xls file with 10 sheets. In each sheet I have two tables of size 10 x 10, one starting at position A4 and the other starting at N4. All the entries are numbers.
(Note that ...
- 113
1
vote
1
answer
180
views
Excel conditional formatting with two NOT functions - NOT Match and NOT Blank
I essentially need help making a formula that highlights a cell when the cell isn't blank, and there aren't any matches in two specific columns. My current formula that isn't working is: =IF(AND(NOT(...
- 11
2
votes
1
answer
50
views
Separately color all rows for unique clients listed in one column
I am a relative Excel noob, and to that end, forget about Excel macros. I'm here because this seems to be where the GOATs congregate, and I really need some help.
I have an enormous data set that ...
- 23
0
votes
1
answer
67
views
Excel - status (online/offline) corresponding to concrete number
I cannot deal with the below tasks, and need your help!
The thing is that I need to use a formula to solve this (not just copy-paste, assuming that the data will be much bigger). Basically, I need to ...
1
vote
2
answers
103
views
Conditional Formatting Excel: If cell C3 is closer to ZERO value than cell A3, I want cell F3 to display "Correcting" shaded green
I need a conditional formatting formula that will enter unique text and shade the cell to identify if a "trader" is correcting their borrowing position.
Context: traders borrow and loan &...
- 11
0
votes
1
answer
140
views
Conditional formatting based on cell on different sheet
I have two sets of data (21x14 sets of cells), on different sheets (but in corresponding cells therein).
Conditional formatting within the sheet works (e.g. Cell Value > 0, applies to =$B$5:$N$25, ...
- 23
0
votes
1
answer
195
views
Need a Formula or Conditional Formatting rule to apply dynamically to table when filters change
I have a large table, 1300+ rows and up to AS columns. This table has groups of Job numbers and I use conditional formatting to put a line between each set of lines for each job. So, lines 4 to 18 ...
4
votes
1
answer
18k
views
How to change a cells color depending on the value of the cell above it/before it for hundreds of lines
I have hundreds of lines with varying values (currency) and want the cell to change color depending on the value above it eg. Greater than = Green, Less than = Red = Equal to = Yellow. ie:
A1 is $100
...
- 43
1
vote
0
answers
62
views
Dynamically Reference Copied Tables in Conditional Formatting
I created a yearly calendar sheet that would automatically highlight dates that were put into a variety of tables through conditional formatting. For example, if Table1 contained the dates 1/1/2023, ...
- 11
0
votes
1
answer
990
views
Conditional Formatting Rule for running sum less than or equal to a number in another cell
Is there a way to apply conditional formatting or another formula on a multiple range of cells to determine if the combined sum in a range of cells is equal to or less than a value in a single cell?
...
- 13
0
votes
1
answer
66
views
EXCEL FORMULA - Conditional format Date
I am trying to work out a formula for the below specific Critia.
If cell is blank, colour in yellow if date is 2 days away, colour in red if date has 1 day over.
I am trying to build a traffic light ...
0
votes
3
answers
984
views
How to highlight all cells that has been sum up
Imagine I have 4 cells A1, A2, A3, A4
I summed A1 to A3 in cell A4
Is there any formula or conditional formatting that will help highlight Cell A1 to Cell A3 by selecting Cell A4 without clicking on ...
0
votes
2
answers
121
views
In Excel, Format a Number with Intermediate Spacing AND Optional Decimal
I have a series of numbers in Excel that I would like formatted in a certain way and I need some help.
Background:
I work in construction, and am using the Construction Specification Institute's (CSI) ...
- 1
2
votes
1
answer
1k
views
Excel: Conditional formatting formula based on text list
I'm trying to use conditional formatting to highlight text in columns A - I as the information is entered in column L. I tried
=ISNUMBER(SEARCH($L$1:$L$5,A1))
but it only reflects information ...
- 25
1
vote
1
answer
107
views
Excel: How to highlight value if greater than or less than previous column/row's last non-blank value
I have a vehicle data spreadsheet with 3 columns to record the Odometer.
Odometer during repair service or fueling
Odometer at the Beginning of a trip
Odometer at the End of a trip
There are gaps ...
- 13
0
votes
1
answer
349
views
Highlight a cell when information in that cell's row is duplicate in 2 of it's columns
I'm looking for a conditional formatting rule that would highlight a cell if data in that cell's row is duplicated in more than one column. Specifically for this sheet, I want the cell in column B to ...
- 1
0
votes
1
answer
113
views
Microsoft Excel Conditional Formatting for Dates and Prices
I'm looking to conditionally format a table following this general idea; I have short dates in one column and years in the headers for several other columns, Id like to highlight the cell when the ...
- 1
1
vote
1
answer
390
views
How can I create a table with values in all columns that change relative to one another?
I want to create a table in Excel where all the resulting values in the other columns change relative to the raw value I modify. Think of it like a multi-way conversion table, where you get to change ...
- 111
1
vote
0
answers
122
views
Excel: Icon conditional formatting based on column name lookup
I am trying to create a conditional formatting rule for a table which looks up a pass mark in another table and then compares the value to that pass mark. It is meant to be as general as possible ...
- 157
0
votes
1
answer
121
views
Excel Conditional Formatting - Using Formula as Part of a Cell Reference
I am trying to use conditional formatting to highlight a cell if it is blank and a cell in the first column of the same row is not blank. For example, if the conditional formatting is for cell D4, I ...
- 1
0
votes
1
answer
460
views
Automatic Shift Planner in Excel using Conditional Formatting
I want to figure out how to schedule shifts automatically in Excel (Native)
What I'm trying to achieve is this (Attached will help you visualize):
Screenshot describing what I have and what I want to ...
- 1
0
votes
2
answers
4k
views
Changing Cell Color based on Multiple Cells
I would like to know how I can set the Cell A to auto change color to red if 3 out of 4 cells (B through E) have a "Y" value.
Screenshot provided for reference
- 1
-1
votes
1
answer
88
views
Highlight rows when all values are for Order Number
I have a spreadsheet with two columns. One column is Order Number and the other one shows its status. As shown in the screenshot below:
Sample Data Sheet:
I want to highlight all the rows when the ...
0
votes
1
answer
2k
views
In Excel, how to apply graded color scale (with conditional formatting) only if cell value is greater than 5?
Suppose I have this dataset (the variable is not important in this case)
I would like to add a color scale for % Missing column, with light red being the lowest value and dark red being the highest ...
-1
votes
1
answer
2k
views
Add until a certain value is reached and return the content of another cell
So I have the given table.
The formula will be in B6. The problem look like this: first I need to test if B2 is >= than B5. If it is I need to return B1 (Week 1), else add B2+C2 and test if the ...
- 1
0
votes
0
answers
20
views
PivotTable Conditional Formatting
I'm having trouble to understand how to apply PivotTable Conditional Formatting.
Homepage have a pivottable and a 'Date' filter.
Dataset have columns like:
Provider | Date | OC Number | Invoice Nº | ...
0
votes
1
answer
124
views
Stopping Excel Conditional Formatting rules changing between tabs
So I have set up a worksheet for my job and it is spread out between 3 different excel tabs. I created a number of different Conditional Formatting Rules to set up all the sheets in the same way to ...
- 1
0
votes
0
answers
26
views
Possible to implement more code, so that highligted dates does'nt show until "in progress" is written
I am coordinating a large amount of production orders that are linked to thereown projects.
In the worksheet that I am working on I have created a calendar which
I have managed to highlight weekend ...
- 33
0
votes
1
answer
2k
views
How to highlight specific dates in an excel calendar based on start and end date?
I am coordinating a large amount of production orders that are linked to thereown projects. In the worksheet that I am working on I have created a calendar which I have managed to highlight weekend ...
- 33
0
votes
1
answer
1k
views
Conditional formatting based on selection from a dropdown list
I have a spreadsheet that is used as a sort of a schedule. Each person has their own ID number and the ID number is shown in a distinct cell. So if my ID is 41, I might see myself scheduled 9-12 on ...
- 3
0
votes
1
answer
1k
views
Highlight entire rows when values in a single column are unique (conditional formatting)
I have a spreadsheet with several columns of data and a couple thousand rows. Each row contains a product and each column contains details about that product.
Example:
Row #
Category ID
Item
Item ...
0
votes
1
answer
7k
views
How to conditionally format if not on list?
Every tip online about conditional formatting and a list is about highlighting cells that match on the list. How can I highlight cells that don't match (ignoring blank cells).
For example, a list of ...
- 5
0
votes
1
answer
93
views
How to setup conditional highlight between two cells:
Looking to understand how to highlight one cell in one column based on what a cell in a neighbor column says.
Column H, in my spreadsheet, displays a differing number of required hours to graduate and ...
- 1
1
vote
1
answer
2k
views
Change Color Based on Color Value Defined in Cell
I want to use conditional formatting to change the color of cell B1 to the color I have defined in cell A1 (using hex values or anything else that will work).
For example, if I have "#FF0000"...
- 13
0
votes
1
answer
494
views
Using conditional formatting to highlight cells that exceed the criteria below
I'm working on a spreadsheet that lists width of a product in cell A, and height of a product in cell B. I'm trying to apply conditional formatting to highlight these cells if they surpass the limits ...
- 3
1
vote
1
answer
467
views
Formulas - Conditional Formatting
I need the cells from Aug to Dec to be formatted automatically based on the "plan numbers" if actual numbers are higher (green); if lower (red)- I'm trying to set it up so when data comes (...
- 15
0
votes
1
answer
1k
views
Excel: Conditional Formatting - Two rules for one cell
I currently have conditional formatting set up to highlight a cell (E3) red when a payment is made after the due date. However, I have a "late fee paid" column. I want to add a rule where if ...
0
votes
0
answers
100
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 = ...
- 95
1
vote
1
answer
3k
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
2
answers
81
views
Specifying Today's Tasks in Excel in a separate column, for separate products and separate clients
I have a list of various clients of which each client has some of the 4 products we provide monthly service for. But each product has a different date on which we have to perform the services for the ...
- 1
1
vote
1
answer
755
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 ...
- 672
0
votes
2
answers
623
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.
- 1
1
vote
1
answer
1k
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 ...
- 13
0
votes
2
answers
1k
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, ...
- 1