Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 30th 05, 06:07 PM posted to microsoft.public.excel.worksheet.functions
SCOOBYDOO
 
Posts: n/a
Default 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   Report Post  
Old November 30th 05, 06:36 PM posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default 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   Report Post  
Old November 30th 05, 06:58 PM posted to microsoft.public.excel.worksheet.functions
Plantimacros
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formating using formulas arifnj Excel Worksheet Functions 4 October 27th 05 01:56 PM
can i freeze conditional formating to copy to another worksheet Chris Lane Excel Discussion (Misc queries) 1 October 12th 05 06:53 PM
VLOOKUP & Conditional Formating Help. Excel'ed Failures Excel Discussion (Misc queries) 6 August 16th 05 04:46 PM
Conditional Formating Extreme Question Heather Excel Worksheet Functions 5 May 8th 05 08:06 PM
How can I use HYPERLINK in a conditional statement between sheets Mikey Excel Worksheet Functions 1 May 3rd 05 08:07 PM


All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017