All Questions
160
questions
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
49
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
69
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
176
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
65
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
98
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
137
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
193
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
16k
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
936
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?
...