ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional formating on if statement (https://www.excelbanter.com/excel-worksheet-functions/58000-conditional-formating-if-statement.html)

SCOOBYDOO

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

Duke Carey

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


Plantimacros

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