Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formating on if statement
Hi, I have 3 workbooks, 1st one I will call 'old', 2nd one 'New' and 3rd
'Comparison'. The 3rd workbook contains the if statement to compare the same cells in the old and new workbook and therefore these cells contain true or false. I would like to build a conditional format which identifies which false is from which original file i.e. cell g3 and g5 may say false but the false in g3 relates to the new file and the false in g5 relates to the old file - I hope you have followed this!! Alternatively if a conditional format can not be used is there another way to compare the old and new file and identify the result from the new file? Many thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formating on if statement
If you think about your statement you'll see that the FALSE values relate to
BOTH workbooks. If the value in one doesn't match the value in the other... Unless there's some independent way to determine which value is OK & which one is not, then all you know is that they are not the same. "SCOOBYDOO" wrote: Hi, I have 3 workbooks, 1st one I will call 'old', 2nd one 'New' and 3rd 'Comparison'. The 3rd workbook contains the if statement to compare the same cells in the old and new workbook and therefore these cells contain true or false. I would like to build a conditional format which identifies which false is from which original file i.e. cell g3 and g5 may say false but the false in g3 relates to the new file and the false in g5 relates to the old file - I hope you have followed this!! Alternatively if a conditional format can not be used is there another way to compare the old and new file and identify the result from the new file? Many thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formating on if statement
"SCOOBYDOO" wrote: Hi, I have 3 workbooks, 1st one I will call 'old', 2nd one 'New' and 3rd 'Comparison'. The 3rd workbook contains the if statement to compare the same cells in the old and new workbook and therefore these cells contain true or false. I would like to build a conditional format which identifies which false is from which original file i.e. cell g3 and g5 may say false but the false in g3 relates to the new file and the false in g5 relates to the old file - I hope you have followed this!! Alternatively if a conditional format can not be used is there another way to compare the old and new file and identify the result from the new file? Many thanks Hi. You should add some conditions into your statement ir order to get the answer in the result of your formula. For example: =If('[Old.xls]Sheet1'!A1='[New.xls]Sheet1'!A1,"Equal",if(and('[Old.xls]Sheet1'!A1="",'[New.xls]Sheet1'!A1<""),"New",if(and('[Old.xls]Sheet1'!A1<"",'[New.xls]Sheet1'!A1=""),"Old","Error"))) With this kind of formula, if the values of evaluated cells are exactly the same you get "Equal", if Old is empty and New have some data, you get "New", and if New is empty and Old have some data, you get "Old". Pay attention what kind of argument separator are you using: (,) or (;). Plantimacros |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Conditional Formating Extreme Question | Excel Worksheet Functions | |||
How can I use HYPERLINK in a conditional statement between sheets | Excel Worksheet Functions |