Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2010, 12:35 PM
jerrymbna22 jerrymbna22 is offline Excel 2007 - Question on conidial formatting? Windows XP Excel 2007 - Question on conidial formatting? Office 2007
Novice
Excel 2007 - Question on conidial formatting?
 
Join Date: Mar 2010
Posts: 3
jerrymbna22 is on a distinguished road
Default Excel 2007 - Question on conidial formatting?

I think this is a conditional formatting question. I feel it’s best to describe an example, for my question. If cell 1a and 2a have the same date, I want cell 3a to atomically populate “First Time”; If cell 1a and 2a have different dates, I want cell 3a to atomically populate “Follow Up”. How do I accomplish this?




thanks
Reply With Quote
  #2  
Old 03-23-2010, 03:42 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Excel 2007 - Question on conidial formatting? Windows XP Excel 2007 - Question on conidial formatting? Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Hi,

Add this formula to cell A3:

Code:
=IF(A1=A2,"First Time","Follow Up")
Cheers,
Reply With Quote
  #3  
Old 03-24-2010, 11:48 AM
jerrymbna22 jerrymbna22 is offline Excel 2007 - Question on conidial formatting? Windows XP Excel 2007 - Question on conidial formatting? Office 2007
Novice
Excel 2007 - Question on conidial formatting?
 
Join Date: Mar 2010
Posts: 3
jerrymbna22 is on a distinguished road
Default thankyou

ConneXionLost worked excellent. Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Whacked formatting in tables (2007) Roscoe Word Tables 6 06-11-2010 02:48 PM
Excel 2007 - Question on conidial formatting? Date Formatting in MS word 2007 Karthick Word 4 01-19-2010 05:54 AM
Excel not saving all data and formatting TRT Excel 2 04-09-2009 12:51 PM
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM
Excel 2007 - Question on conidial formatting? Excel Question ---Concatenation! jamal420 Office 1 06-13-2005 02:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft