All Questions
161
questions
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
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 ...
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
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 ...
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, ...
0
votes
0
answers
31
views
Excel check if any values are present in more than one range
I have 5 little groups of cells on my spreadsheet, set out like this:
PERSON 1
AM PM
MON
TUE
WED
THUR
FRI
PERSON 2
AM PM
MON
TUE
WED
THUR
FRI
etc...
The user then ...
0
votes
1
answer
143
views
Excel 2019 - Conditional Formatting specific cells based on their values as well as value in another cell
I have a table like this
|Physics| |Chemistry| |Math| |English| |Fail/Pass|
50 30 60 25 F
60 25 50 70 P
I want to highlight those cells ...
0
votes
1
answer
2k
views
check if any text within cell contains the text of any cells within a range
I'm looking for an Excel formula (which ideally also works within Google Sheets) that checks whether any part of the text value of a given cell contains the full text value of any previous cell within ...
-1
votes
1
answer
68
views
MicroSoft Excel- Blank cell formatting
I would like to condition format a row on the criteria that the last cell in the row is blank.
Once text is entered into the cell (O3) I would like to conditional format (Yellow highlight) to go ...
0
votes
1
answer
49
views
How do I conditionally format to highlight cells with =-IF in the formula?
I have a large workbook with many sheets, each with two sections in them.
One section, the formulas should begin
=IF(ISNA(...
and in the other section the formulas should begin
=-IF(ISNA(...
...
1
vote
1
answer
130
views
Excel Formula returns "Refers to empty cells"
I am using this formula for a running balance:
=IF(AND(ISBLANK([@[EHEAP AMOUNT]]),ISBLANK([@CREDIT])),"",R1-[@[EHEAP AMOUNT]]+[@CREDIT])
EHEAP AMOUNT is the debit column, CREDIT is credit
...
0
votes
2
answers
554
views
How to conditional format ONLY the first row that meets a condition?
I have an amortization table with a date next to each row. How do I highlight ONLY the first row that is a larger date than today's date?
Let's say the date column starts at A13. Obviously this...
=...
0
votes
2
answers
7k
views
Changing font colour in a cell with a formula
I have a spreadsheet that is used by a group of people. Its purpose is for service admin to plan runs for service techs weekly.
They input each job and a travel & task estimated time in minutes ...
0
votes
2
answers
285
views
Complex Conditional Formatting
I'm a CPA with lots of Excel experience, but can't seem to figure out an answer to this question (of my own). Is there a way to apply conditional formatting for the below example:
EXAMPLE: I have a ...
1
vote
1
answer
1k
views
Excel - How to Match duplicate rows, with a unique ID - from a cloned and consolidated version of the same sheet
I've been given ownership of a document to manage and it's a mess, I want to tidy it up, but have ventured out of my depth unfortunately :(
I have two sheets
Sheet A (many instances of rows with ...