different cell

Is there a conditional formatting that would reflect to (cell) based on (value chosen from drop-down list in different cell)? Condition : All cells containing the value of (Yes) the next cell will be highlighted in gray and not allow anything to be typed; if (no) the next cell will be...

A1=2, A2=3. Then C1 should be the sum(2+3=5). But next time we change the values in A1 and B1 as "4","3" then the sum- 7 stored to B2, not B1. ....to B3. Thus the B1 not changing yet. What can do?

Hi everyone, Wonder if anyone can help. I have the below formula which works fine. =SUM(IF(YEAR('Fixtures & Fittings'!$G3:$G65536)=INDEX!D$17,'Fixtures & Fittings'!$I3:$I65536,0)) However if I copy the formula into another cell it doesn't work? It is exactly the same formula but doesn't...

I am developing a sheet to do some debt analysis. I have an input cell for loan value (B1), interest rate (F1), term (months)(H1), and payment(J1). I also have a set of cells that will calculate each of these values individually, given the other 3 values (J4-7 respectively). What I am trying...

I'm setting up a form for people to enter information into. I have a free-form text field that users need to be able to type into, so I can't put a formula into it. However, I want a value to be "injected" into it upon a certain condition based on a formula from another cell "watching" that...

I have a function and I want it to output one word in the current cell and one in the cell to the right (i.e., the next column). Is there a way to write this in VB? So, something along these lines (though this doesn't work): Function test(word1 As String, word2 As String) test = word1...