Excel 2007

jerrymbna22 · #1 03-23-2010, 12:35 PM

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

ConneXionLost · #2 03-23-2010, 03:42 PM

Hi,

Add this formula to cell A3:

Code:

=IF(A1=A2,"First Time","Follow Up")

Cheers,

jerrymbna22 · #3 03-24-2010, 11:48 AM

ConneXionLost worked excellent. Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Whacked formatting in tables (2007)	Roscoe	Word Tables	6	06-11-2010 02:48 PM
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 Question ---Concatenation!	jamal420	Office	1	06-13-2005 02:19 PM