Effect One Cell By The Condition Of Another Cell
Jan 2, 2010
Is it possible to effect one cell by the condition of another cell. For example cell A1 turns blue when cell C4 meets a certain condition.
The 1st sheet my users see after install requires a little patience. he/she has to put mandatory information into certain cells. I would like to blank out the rest of the sheet (formatting and all) until this information is supplied. So that the necessary initial requirements stand out alone.
This is a budget package. The user has to initially supply - weekly wage - start date, Account names, estimate amounts that will be spent on each account per week, before the program can work
I do supply instructions - but hey! who reads them? They get refered to perhaps after the 1st stuff up.
A form may work - but the sheets are already laid out with spaces in the wrong places for forms (so the Form Wizard seems to indicate) - beside the fact that I wouldn't have a clue how to make a form
View 9 Replies
ADVERTISEMENT
Nov 26, 2008
I wasnt sure how to name this problem, but here goes.
View 3 Replies
View Related
Jan 5, 2012
Here's a problem I'd like to be able to solve in VBA:
Retrieve the current cell color (let's say A1 = 'green')
Format A1's cell colors (using the VBA equivalent of the 'Format Cells' / 'Fill' / 'Fill Effects' / '2 color Gradient' feature) so that the background cell color (color 2) is set to 'green' with color 1 being set to 'white' with a shading style of "From Center"
I'm using Excel 2010.
View 4 Replies
View Related
Sep 24, 2013
I have one column that contains a monetary amount (column AQ) , and another that contains text reading either "inflows" or "outflows" (column AC)
When AC says "inflows", AQ should be positive, and when AC says "Outflows", AQ should be negative.
I need the text in column AQ (the monetary amount) to become red when the the opposite is true.
i.e. When AQ is negative and AC says "Inflows", AQ should become red. And when AQ is positive and AC says "Outflows", AQ should become red.
View 2 Replies
View Related
Mar 24, 2014
I am trying to perform a calculation in a cell that leaves the value 0 if before Feb 2014, changes to the value of another cell in Feb 2014 and leaves the value unchanged if after Feb 2014. I can get to the Feb 2014 value but after that month the value changes to 0.
The Cell formula that I am trying to use is as follows:
=IF(YEAR($A$3)<2014,"0",(IF(YEAR($A$3)>2014,H114,(IF(MONTH($A$3)<>2,H114,AA118)))))
A3 contains TODAY()
H114 is the cell being calculated
AA118 is the cell containing the calculated value for the current month.
View 2 Replies
View Related
Mar 25, 2013
formula to copy a cell to a new cell if the previous cell meets the condition.
i have attached an example work book.
so what im looking for is on sheet 1 there is a table and cell G9 shows Apples. on Sheet 2 is a second table where the information is in slightly different rows.
I want to be able to [When Sheet 2 Column C = Sheet 1 Column G Then Paste Sheet 2 Column D into Sheet 1 Column H (next to Apples)]
Then i would like in Cell J9 to look something like [When Sheet 2 Column C = Sheet 1 Column G Then Paste Sheet 2 Column F into Sheet 1 Column J]
and i would like Cell I9 to look something like [When Sheet1 Column J = Sheet 1 Column L Then Paste Sheet 1 Column M into Sheet 1 Column I]
G9 H9 I9 J9 L M <-- hidden C D E F
Sheet 1 |Apples| 20 | Hot |Average | Hot | Average Sheet 2 |Apples| 20 | AP | Average
View 1 Replies
View Related
Jan 26, 2007
how can we disable/enable a cell based on a condition which is dependent on other cell data
View 4 Replies
View Related
Feb 9, 2007
Is it possible to use a formula to shade a cell dependent on a condition? I have tried an if formula (see below) but it is incorrect. =if('November 2006 SVOC'!B6>'March 2006 SVOC'!C6,'November 2006 SVOC'!B6 [red],if('November 2006 SVOC'!B6<'March 2006 SVOC'!C6,'November 2006 SVOC'!B6 [blue],))
View 3 Replies
View Related
Aug 27, 2008
I have 2 workbooks, A (source) and B (destination).
Workbook A has 1 sheet named 'master' and has 10 columns a:j
I would like to copy a range of data in worksheet 'master' for entire 10 columns while the cell value (moving down worksheet) of the next cell in column A is greeater than the current cell. eg. if cell values of range a1:a6 = 1 then cell value a7 =2, then copy range a1:j6 to workbook B in sheet 'r1'.
Then I would like to go back to Workbook A sheet 'master' and begin process again starting from where it left off at a7.
View 9 Replies
View Related
Apr 29, 2009
how to include a condition in the condition? What I mean is in this set of numbers:
1000(A) 1000(B) 1000(C) 1200(D) 500(E) 1000(F)
I want excel to point out (with a 1, True, x, whatever) if (B) is greater than (A) by 10% or more and if (C) is greater than (B) and so on. I know I cant use =if(C>B,1,0)...Im just unsure how to include the % in the function
View 2 Replies
View Related
Sep 12, 2007
I am currently doing a spreadsheet and require cells in column f (which have monetry values entered) to colour in different colours depending on whether there is a yes or no value in column e.
View 2 Replies
View Related
Oct 9, 2009
Cell h2 Gives me a date =SUM(TODAY())+g2
I want to give the same cell a second condition
If(j2<25%,"--")
The problem is I want to write both the date range calculation and the If statement in the same cell but I dont know how to link them.
View 2 Replies
View Related
Feb 15, 2014
I have a data set that is not structured well. I need to move information into multiple rows that share the same ID #. In the attached example, for cell C6, C7, C8 and C9 I want "Sunny 60" (ID=1). In C13-C16 I want "Sunny 65" (ID=2) and in C20-C23 I want "Raining 55" (ID=3).
ABCD
1ID
2info1weatherSunny
3info1Temp60
4info1Time7:50PM[code]...
View 1 Replies
View Related
Apr 24, 2014
I'm a structural design engineer and I want to develop my own spreadsheet to calculate required area (mm^2) of reinforcement bars in concrete to avoid concrete cracking due to temperature rise in summer. Available input are min area of reinfor (cell A3), crack width limit (A1) and calculated crack with (A2). For example.....
A1= Crack width limit 0.2mm. A2= Calculated crack 0.28mm (which is higher than the limit 0.2mm; therefore min area of reinfor A3= 1450mm^2 is insufficient to stop concrete from cracking). Now......to stop cracking, I want cell B1 to take 1450 from A3 and keep increasing it until the condiotn A1>=A2 is met and I want cell B1 to display that increament( lets say 1780mm^2). I hope you do get what exaclty I want to do in excel
I don't have much experience in Excel so I don't know anything about Macro/VBA coding etc. Can we do a simple thing like this B1=IF(A1>=A2,A3,somthing here to keep adding a value to A3??) OR do we have to give pragamming code???
If it has to be Macro/VBA, complete coding with an instruction where to write it.
NB: There are several calculations done with manual inputs within the sheet to derive the A2 (0.28mm) value
View 9 Replies
View Related
Jun 5, 2014
How to delete cell with some condition?
View 1 Replies
View Related
Jun 18, 2007
I got 2 colums:
Column A: Column B:
EUR 1.00
USD 2.00
USD 3.00
EUR 4.00
As you may have guessed I now want Excel to check in column B the content of column A and to change format accoring to content:
Goal:
A B
EUR 1.00 €
USD 2.00$
USD 3.00$
EUR 4.00€
I want to stress, that a solution using macros isn't possible.
View 9 Replies
View Related
Mar 31, 2007
to write a VBA code that will have a cell RE-calcuate an excel formula ONLY if a date i have in a cell to the left of it is greater than another cell in the worksheet.
These dates will change so i cannot have the value entered into the VBA code, but rather linked to the data i would enter into the said cell.
View 8 Replies
View Related
Feb 19, 2014
I'm trying to write a formula that would filter data from one column based on condition entered in a cell. This one works great with single numbers or text in a reference cell:
=IF((a2=C$3);a2;"") copied down the column
but if I try to filter all numbers greater than 2 (I eneter ">"&2 in cell c3) it doesnt work. Is it possible with if formula or should I use something else?
View 4 Replies
View Related
Feb 25, 2014
How to get the cell value returned meeting condition both in row & column as well.
Sample sheet attached : Book1.xls‎
View 3 Replies
View Related
Jun 9, 2014
I want to use two separate Unit of measurement according to two condition in a same cell.
View 3 Replies
View Related
Jan 22, 2013
I run a small business, and I use Excel to track my books especially receivables.
I have a list of Invoice numbers and Invoice amounts for every customer.
My customers pay periodically (every two weeks, etc), but the tricky part is that the amount paid may not necessarily reflect the exact amount of invoice still being owed. And there may be two, three or five invoices outstanding at any one time.
I have another column which contains payment amount made by customer.
What I would like to do is to highlight the INVOICE NO. cell once the amount of that particular invoice has been bypassed by the total amount paid (i.e. the full amount of that invoice has been paid). Then I can close that invoice.
Here's what my list looks like roughly.
INV NO. - INV AMOUNT - AMOUNT PAID
INV1 ------- 100 ------------- 80
INV2 ------- 250 ------------- 90
INV3 ------- 150 ------------- 80
TOTAL ----- 500 -------------270
View 13 Replies
View Related
Mar 10, 2014
I'm trying to set it up so that if a particular cell has any data in it, the contents of a different cell get sent to another. I want the no data/data to serve as a trigger.
As an example, if I put anything into cell A3, I want the contents of cell A1 to copy to H1. I'd also like it to be dynamic so that if I put something into cell B3, the contents of B1 get copied to H1, etc.
View 4 Replies
View Related
May 20, 2014
I have a workbook sheet change condition that, when triggered runs the following code (amongst others).
[Code] ......
What I would like is to amend the above (possibly in a loop?) so that it skips the rows in which the value "New" features in range F17:F190.
So basically Autofill as per the code but leave the values in the cells of the range in which New features in range F17:F190
View 4 Replies
View Related
Dec 11, 2006
I have 2 sheets in an excel folder and in fact I would like to create a macro to tranfer a row of the chart present in Sheet 1 if a cell is matching a condition so that the macro identifies each row of the chart in the Sheet 1 and transfer the row in the other sheet if the value in the column A (Chart Sheet 1) is equal to 1 :
sheets("Global Sheet").Select
Range("A1").Select
If activecell = 1 Then Transfer A1:J1 in the other excel sheet ( anywhere)
View 12 Replies
View Related
Dec 11, 2007
I have 2 cells that take imported info. from a DDE server. Lets say one cell currently has a number of 9.00. Lets say the 2nd cell has a number of 1.00. Lets say the 1st cell over time goes from 9.00 to 8.50 to 7.33 to 6.67 and so on....it continues to go down. At the same time, lets say the 2nd cell is gaining and going from 1.00 to 1.33 to 2.00 to 2.67 to 3.33, and so on...and it continues to go up. I want to have a certain sound play once the two cell numbers "cross" each other. I only want this sound to play one time and not every "tick" as they cross and go up/down. Can someone show me how to program this?
View 14 Replies
View Related
Jan 18, 2009
I had an report and the rows of the report needs to be colored based on another cell value. My layout looks like this:
A1B1C1D1AVG
1011121330
14151617100
18192021400
For each cell, i need to compare the value of cell with that value in AVG coloumn and if condition is met, cell should be colored. Eg : If first cell value under A1 is Less than 0.2 * AVG of first row then color of the cell A2 should be red. After coloring the entire rows, then i should check and color the header row based on the color of Rows.
I tried first one, i,e coloring the rows based on conditional formatting and then written VB code to compare the color of rows and colored the header row. But the color index used in conditional formatting and the code are mismatching and the desired output is not coming.So decided to write code for coloring the rows cell.
View 4 Replies
View Related
Nov 24, 2009
I have a worksheet where two columns of data are written. In another worksheet I have a list of data in one column. In column next to it (so the rows are the same) I am trying to write a list of sumif formula, where the range is first column of the first worksheet, condition is a value of the cell next to where I am writing the sumif equation (list of data) and the sumrange is the second colummn in the first worksheet. I can't get it. I tried with --- "C" & i --- but I get an error saying expected:end of statement. It goes like that:
View 2 Replies
View Related
Sep 21, 2013
I want to have a condition which will check if the value in cell is present or not and based on that i have to display result in a cell.
Eg: In Sheet1, in column D i have 4 values (Simple, Complex, Medium Complex, Very Complex)
In Sheet 4, we have numeric values to Simple, complex...Like below
Complexity Estimation
Simple 2hrs
Complex 4hrs
Medium Complex 2.5hrs
Very Complex 6hrs
In Sheet5, we have values defined in % like below:
Requirement Analysis
15%
Design
20%
Coding
20%
System Testing
15%
[code]....
In column G of Sheet1, we have to write a function or formula which we do below calculation.
IF (Sheet1!D3="Simple") then Sheet1!G3=Sheet5!B2(ie.15%) of Sheet4
Similarly i will have Sheet1!D3 values as Complex,Medium Complex,Very complex
View 2 Replies
View Related
May 28, 2008
I have text in Q2:Q30 this text is spread out in N2:N500
then i have Numbers in K2:K500
what i would like to do is to
find Q2 in N2:N500 (can be there many times) and add numbers from K2:K500 where found into R2
example Q2 is Denmark
I have Denmark in N40, N60, N490
Now in R2 i would like to add K40 + K60 + K490
i have started with this
=IF(ISNUMBER(MATCH(Q2,$N$2:$N$500,0)),SUM but now i`m stuck
View 9 Replies
View Related
Jan 1, 2010
I have so data I am trying to combine based on count value of investment on Col A. If it appears more than once on col A then I want the col B values on col D. I have macro that works but I need make sure if Col B have any TRAC and TRL1 then I want to add that on Col D. For example so Col D1 would be EURX, TRL1 at 83.50, FTID and Col D5 would be TRAC at 87.88, Markit. Below is the macro.
View 9 Replies
View Related
