All Questions
25
questions
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
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
1
answer
3k
views
How can I get Excel to use conditional formatting per day of the week using dates and not the words "Monday, Tuesday,"
I am working on a delivery schedule for the company I work for and we want to be able to have the dates color coded by days of the week. But we often have several deliveries on the same date, so when ...
0
votes
1
answer
440
views
Can't remove hidden characters?
I'm trying to make a simple tool for my job where I can decline job listings for a specific reason simply by checking their boxes and then copying and pasting the final cell where it will compile all ...
0
votes
1
answer
139
views
How to output the results of 2 different cells into a single cell in Excel?
I am trying to get D5 and D6 into cell C6 so that I looks like this ($15,000.00 - $25,000.00) The formula I used to do this is :
=DOLLAR(D5)&" - "&DOLLAR(D6)
My first question is, ...
0
votes
1
answer
89
views
Highligh group of cells based on a condition - Excel
I have the following table consisting of three rows, the outcome is to highlight all cell on a single row only if more than 8 following cells has a value 1.
For example in the first row, I have 6 ...
1
vote
2
answers
72
views
Please help me stop Excel 365 enterprise from changing my text formatted cells into formulas
I have a spreadsheet where I need to use strings that contain a couple of dash/ minus ( - ) signs in cells, but it will not stop truing to recognize them as formulas! I have already formatted the ...
0
votes
3
answers
2k
views
Excel text formatting function interpreting 'E' in string as exponent
I have exported some data records from a database into spreadsheet form for final formatting. One of the key fields is text in the form of '123456E72'.
I have a formatting formula that formats the ...
0
votes
1
answer
53
views
Microsoft Excel formula not working properly
I want to format a cell which is greater than 365 value. The problem is I put the formula of datedif(a1,b1,"d")&" "&"Days" and the result in the cell is 390. I ...
0
votes
3
answers
3k
views
Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells
Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells or does not find the lookup value.
I do not want to suppress the zeros by formating them out. I want ...
1
vote
2
answers
575
views
How to concatenate cell with the Amount and cell with Currency Code?
This keeps bugging me, I've checked various Excel forums but it seems this is either a trivial problem (an I'm an idiot) or this simply wasn't asked before:
Let's say I have two columns with data ...
0
votes
1
answer
130
views
Excel - #VALUE! error message
I type $1000 in cell D31. I type =D31+50 in cell D32 because I want D32 to show $1050. I then want to copy that formula into the next 100 cells in row D so that the value in each cell is $50 higher ...
1
vote
3
answers
2k
views
Excel MATCH function seems to be broken. Issue description and investigation details. Any explanation or solution to this?
I'm a fairly intensive and experienced Excel user, used to work with INDEX and MATCH functions and with strings, so I am also used to the typical issues with errors with the MATCH function due to ...
0
votes
1
answer
453
views
Excel 2016 Chart > Date and Text on the same Axis
I received an interesting question yesterday during at work. Is it possible to have Date and Text values on the same Axis in Excel Chart, but that this "text" is actually formatted or somehow ...
0
votes
1
answer
1k
views
Format blank cells based on text in another cell
I would like to apply conditional formatting to a sheet, however, cant figure out the right formula.
The formatting would only apply to BLANK cells in columns S to AT based on text in in column I.
...