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 |
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 |
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 |
All times are GMT +1. The time now is 11:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com