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 ...
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 ...
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 "...
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 ...
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:
...
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 ...
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(...
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 ...
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 &...
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, ...
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
...
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, ...
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?
...
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) ...
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 ...
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 ...
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 ...
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
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 ...
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 ...
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 ...
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 ...
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
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 ...