| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assistance with a formula
I am comparing data from 2 columns. What I want to do is have a formula that
says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance with a formula
hi
formulas return values, they cannot perform actions such as highlight cells. but if you put the formula in conditional formating, it would work. formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color. regards FSt1 "Bookmdano" wrote: I am comparing data from 2 columns. What I want to do is have a formula that says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance with a formula
If you are talking about formulas in conditional formats, you don't need the IF
AND(A1-B110000,(A1-B1)/A10.1) is all you need. Just put it in the cell that needs the condition set. Look, I didn't hit enter between Subject and message. :) -- HTH, Barb Reinhardt "FSt1" wrote: hi formulas return values, they cannot perform actions such as highlight cells. but if you put the formula in conditional formating, it would work. formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color. regards FSt1 "Bookmdano" wrote: I am comparing data from 2 columns. What I want to do is have a formula that says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance with a formula
cool. gaining control.
thanks regards FSt1 "Barb Reinhardt" wrote: If you are talking about formulas in conditional formats, you don't need the IF AND(A1-B110000,(A1-B1)/A10.1) is all you need. Just put it in the cell that needs the condition set. Look, I didn't hit enter between Subject and message. :) -- HTH, Barb Reinhardt "FSt1" wrote: hi formulas return values, they cannot perform actions such as highlight cells. but if you put the formula in conditional formating, it would work. formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color. regards FSt1 "Bookmdano" wrote: I am comparing data from 2 columns. What I want to do is have a formula that says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance with a formula
Thanks! Both solutions give me what I need. I like the True/False response.
But is there anyway to highlight or change font color if there is a True response? "Barb Reinhardt" wrote: If you are talking about formulas in conditional formats, you don't need the IF AND(A1-B110000,(A1-B1)/A10.1) is all you need. Just put it in the cell that needs the condition set. Look, I didn't hit enter between Subject and message. :) -- HTH, Barb Reinhardt "FSt1" wrote: hi formulas return values, they cannot perform actions such as highlight cells. but if you put the formula in conditional formating, it would work. formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color. regards FSt1 "Bookmdano" wrote: I am comparing data from 2 columns. What I want to do is have a formula that says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance with a formula
yes.
add a second condition, same formula but reverse the true/false part. regards FSt1 "Bookmdano" wrote: Thanks! Both solutions give me what I need. I like the True/False response. But is there anyway to highlight or change font color if there is a True response? "Barb Reinhardt" wrote: If you are talking about formulas in conditional formats, you don't need the IF AND(A1-B110000,(A1-B1)/A10.1) is all you need. Just put it in the cell that needs the condition set. Look, I didn't hit enter between Subject and message. :) -- HTH, Barb Reinhardt "FSt1" wrote: hi formulas return values, they cannot perform actions such as highlight cells. but if you put the formula in conditional formating, it would work. formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color. regards FSt1 "Bookmdano" wrote: I am comparing data from 2 columns. What I want to do is have a formula that says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance with a formula
That formula (which gives the TRUE/ FALSE response) was what was recommended
you should put into your Conditional Formatting/ Formula IS condition. Just remember to put the = at the beginning of the formula, bercause Excel doesn't assume it, even in CF/ Formula Is. -- David Biddulph "Bookmdano" wrote in message ... Thanks! Both solutions give me what I need. I like the True/False response. But is there anyway to highlight or change font color if there is a True response? "Barb Reinhardt" wrote: If you are talking about formulas in conditional formats, you don't need the IF AND(A1-B110000,(A1-B1)/A10.1) is all you need. Just put it in the cell that needs the condition set. Look, I didn't hit enter between Subject and message. :) -- HTH, Barb Reinhardt "FSt1" wrote: hi formulas return values, they cannot perform actions such as highlight cells. but if you put the formula in conditional formating, it would work. formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color. regards FSt1 "Bookmdano" wrote: I am comparing data from 2 columns. What I want to do is have a formula that says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance with a formula
Thanks for the assitance but I have a new twist. I also need a "True" return
if A1=0 and B110,000. Since I'm dividing by zero (A1) my response is #DIV/0! Any suggestions? "Barb Reinhardt" wrote: If you are talking about formulas in conditional formats, you don't need the IF AND(A1-B110000,(A1-B1)/A10.1) is all you need. Just put it in the cell that needs the condition set. Look, I didn't hit enter between Subject and message. :) -- HTH, Barb Reinhardt "FSt1" wrote: hi formulas return values, they cannot perform actions such as highlight cells. but if you put the formula in conditional formating, it would work. formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color. regards FSt1 "Bookmdano" wrote: I am comparing data from 2 columns. What I want to do is have a formula that says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance with a formula
hi
are you using conditional formating. if so, you should not get a #Div/0 error. only not format in cell. if your are using just the fomula try this. =IF(A1=0,"",IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)) regard FSt1 "Bookmdano" wrote: Thanks for the assitance but I have a new twist. I also need a "True" return if A1=0 and B110,000. Since I'm dividing by zero (A1) my response is #DIV/0! Any suggestions? "Barb Reinhardt" wrote: If you are talking about formulas in conditional formats, you don't need the IF AND(A1-B110000,(A1-B1)/A10.1) is all you need. Just put it in the cell that needs the condition set. Look, I didn't hit enter between Subject and message. :) -- HTH, Barb Reinhardt "FSt1" wrote: hi formulas return values, they cannot perform actions such as highlight cells. but if you put the formula in conditional formating, it would work. formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color. regards FSt1 "Bookmdano" wrote: I am comparing data from 2 columns. What I want to do is have a formula that says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Assistance with a formula
I wasn't using conditional formating. I was just using the formula. I tried
your revised formula but the response was not what I needed. Here's my problem: I am trying to get a True response whenever there was a change of 10,000 or 10%. 2008 2007 Cash 110,000 100,000 Deposits 0 12,000 Receivables 15,000 0 Interest 30,000 15,000 Based on the above data I would expect Cash = False, Deposits =True, Receivables =True and Interest = True. Now I just need a formula to figure this out. One that when divided by a negative number gives me a True or False response. Any suggestions? "FSt1" wrote: hi are you using conditional formating. if so, you should not get a #Div/0 error. only not format in cell. if your are using just the fomula try this. =IF(A1=0,"",IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)) regard FSt1 "Bookmdano" wrote: Thanks for the assitance but I have a new twist. I also need a "True" return if A1=0 and B110,000. Since I'm dividing by zero (A1) my response is #DIV/0! Any suggestions? "Barb Reinhardt" wrote: If you are talking about formulas in conditional formats, you don't need the IF AND(A1-B110000,(A1-B1)/A10.1) is all you need. Just put it in the cell that needs the condition set. Look, I didn't hit enter between Subject and message. :) -- HTH, Barb Reinhardt "FSt1" wrote: hi formulas return values, they cannot perform actions such as highlight cells. but if you put the formula in conditional formating, it would work. formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color. regards FSt1 "Bookmdano" wrote: I am comparing data from 2 columns. What I want to do is have a formula that says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be done? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Assistance | New Users to Excel | |||
| Need assistance with a formula - If then??? | Excel Worksheet Functions | |||
| Assistance with Formula | Excel Worksheet Functions | |||
| Formula Assistance | Excel Discussion (Misc queries) | |||
| Formula Assistance | Excel Worksheet Functions | |||
Hybrid Mode
