BleepingComputer.com: Excel 2003

Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Excel 2003 If / And Statement & Conditional Formatting

#1 User is offline   amyl 

  • Member
  • PipPip
  • Find Topics
  • Group: Members
  • Posts: 62
  • Joined: 10-May 08

Posted 23 September 2009 - 11:48 AM

Hopefully this makes sense.

I am using If / And statements and conditional formatting to pull data from 1 Excel Spreadsheet (that includes multiple tabs) to another Spreadsheet {I am using as a Master spreadsheet to pull all data into}.


Example of current formula Spreadsheet 2 Cell A1 pulling info from Spreadsheet 2 cell H8:
=IF('[Spreadsheet2.xls]Tab,1'!$H$8="good voice tone",("True")) (if it doesn't equal this criteria then it defaults to false).
***Conditional Format is to highlight cells Red if "True" and no highlight if cells=false

Is there a way to pull from multiple tabs in a worksheet {Example: Tab 1, Tab 2, Tab 3, Tab 4} and use multiple cells within each tab {Example: H8, H9, H10, H11} within 1 formula (or can you use multiple formulas for 1 cell?)

This post has been edited by amyl: 23 September 2009 - 11:49 AM

#2 User is offline   tos226 

  • BleepIN--BleepOUT
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Members
  • Posts: 1,412
  • Joined: 21-October 04
  • Gender:Female
  • Location:LocalHost

Posted 23 September 2009 - 06:58 PM

You might be able to pull it off, it you use ARRAY formula. See Help. You need to do Shift-Enter or Alt-Shift enter when you type in OR EVEN EDIT such as fomula, the result would be {=yourFormula} with those curly braces. And your formula should include the range such as H8:H10 from the other worksheet.
I'm not 100% sure I understand your question, so let's hope you can clarify a tad more :thumbsup:

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users