All Questions
49
questions
0
votes
0
answers
27
views
Conditional Format Date From Date In Another Cell
I have three date columns, Manufacture Date (B2), Inspection Date (C2), Future Inspection Date (D2), the Future Inspection Date column looks at columns B2 & C2 to determine the latest date from ...
1
vote
1
answer
57
views
Excel: How to color cells based on condition A = C and the sum of values in B is less than D?
Column A, starting from A1, contains the following values:
sasa
masa
sasa
masa
sasa
sasa
sasa
vasa
vasa
Column B, starting from B1, contains the following values:
2
3
4
5
6
4
1
1
2
Column C, starting ...
1
vote
2
answers
981
views
how do I compare each row of two different columns and highlight the highest value (not formula) in each row?
I have two columns to compare. All cell values come from the ROUNDUP function. =ROUNDUP(C6/D12,0) etc.
I want the larger, or equal, of the two in each row to be green and the smaller red. Using the ...
0
votes
1
answer
390
views
Highlight a row until all cells are filled
I am using conditional formatting to highlight a row if a cell has something entered and will remain highlighted until all cells in that row are filled.
=COUNTA($B$2:$E$1)>0
*Conditional format if ...
-1
votes
1
answer
64
views
Excel formula if multiple conditions
I have A2=1000000, I set the following formula at cell b2. I use if have multiple conditions but it is not working. The formula is
If(
A2>=200000, 0%,
if(
300000<A2>0.5%,
...
0
votes
1
answer
715
views
VBA to place formula based on cell value
i need help, here I am facing an issue with my code
first issue is it give me compile error also it is selecting the source sheet but when i define cell reference along with sheet reference it is not ...
0
votes
1
answer
25
views
Conditional formatting formula removal not working
I have a worksheet with conditional formatting. I need to remove the conditional formulas, but when I do and they are gone, I save the sheet, exit, and re-load the sheet. When I check, the formulas ...
0
votes
1
answer
211
views
Excel; Conditional formatting Date/Time between two columns
I have two columns, for example Column A and B with the below style of set up.
What I am wanting to do is to highlight both columns in a colour based on certain parameters.
For example: If Column B is ...
0
votes
1
answer
770
views
Conditional format if one cell is filled and another is an error
I have this workbook set up with two formula driven columns. Rather than seeing #N/A if column B is not filled, however, I have it appear blank. I am trying to conditional format Column A to turn ...
0
votes
0
answers
38
views
Conditional formating with dates
I have a big database structured like this:
I would need a formula that checks every row (name) and their dates of tests.
If any of the dates is within the current week, the column "Tested this ...
-1
votes
1
answer
104
views
Adding values to different cells depending on conditions - Excel
I am not very good with excel formulas, and I would need some help with a process I want to implement:
Simplifying things, I have an excel sheet (sheet n°1) with rows like this:
Company name | Price | ...
1
vote
1
answer
487
views
Excel Conditional Formatting Formula Changes After I Apply The Rule
Every time I make a new conditional formatting rule it changes and breaks. This happens before I click apply, but after I have created the rule. If I apply the rule it, naturally, applies completely ...
0
votes
1
answer
563
views
Highlight Duplicate Rows When Conditions Met in Multiple Columns i Excel
I am looking for help setting up a conditional formula in Excel that highlights a row when two conditions are met. The goal is to flag when multiple users are working in the same zone at the same time....
0
votes
1
answer
465
views
Conditional Range Reference with NPV
I have a table of payments:
Acct Date Payment
1 1/1/20 200.00
1 2/1/20 200.00
2 1/1/20 300.00
2 1/1/20 300.00
Is it possible to get the NPV for specific accounts ...
0
votes
1
answer
45
views
Excel Conditional Formatting - Lowest value if unmerged cell above meets criteria
I'm trying to use conditional formatting to highlight the lowest value in each row green as long as the unmerged cell above it does not read "N" (as I want that to disqualify the value in that case.) ...