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 ...
- 56.1k
0
votes
2
answers
7k
views
How do I highlight the max values across every column in a pivot table?
Looking for a way to use conditional formatting to highlight the max value in every column of a pivot table.
CommunityBot
- 1
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 &...
- 43.2k
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 ...
- 43.2k
0
votes
1
answer
3k
views
Conditional Formatting for one cell value in a list, another cell blank
Looking for how to do Conditional Formatting for the following rule:
If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. Both ...
CommunityBot
- 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
CommunityBot
- 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 "...
- 2,603
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 ...
- 2,902
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
2
answers
671
views
Excel conditional formatting linked cells blank formula
I have applied conditional formatting to a row so that when one of the cells in the row is not blank, it is highlighted. I have entered a formula into the first cell so that it is linked to another ...
- 56.1k
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 ...
- 2,320
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 ...
- 2,320
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(...
- 16
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 ...
- 1
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,898