If funtion or Conditional

jabaker54 · September 24th, 2014, 04:42 PM

So my head hurts from this one...

I am trying to do a couple of things to match certain criteria. I want table 1 to be able to turn a row red if a.) the name matches and then b.) the date ranges mix.

Lets say this is my data...

Table 1:

A B C
1 John Doe 12/12/2013 12/12/2014
2. Jane Doe 11/12/2013 11/12/2014

------------------------------------------------------------------

Table 2:

A B C
1 John Doe 1/18/2014 2/18/2014
2 Jane Doe 11/13/2014 11/14/2014

----------------------------------------------------------------

Now because John Doe's date ranges mix I want that row to turn red.

Aaliya00 · September 25th, 2014, 03:01 PM

Crazy Bulk Review You really very helpless at the time when you have lean muscles and donât have proper body muscles growth and that canât give you proper effectiveness and such way whatever medications or products you take that donât give that positive result.

Shasur · November 4th, 2014, 01:08 AM

Try the conditional formatting feature in Excel. It should solve your problem (and headache :))

http://office.microsoft.com/en-in/ex...102809768.aspx

Cheers
Shasur

Quote:

Originally Posted by jabaker54

So my head hurts from this one...

I am trying to do a couple of things to match certain criteria. I want table 1 to be able to turn a row red if a.) the name matches and then b.) the date ranges mix.

Lets say this is my data...

Table 1:

A B C
1 John Doe 12/12/2013 12/12/2014
2. Jane Doe 11/12/2013 11/12/2014

------------------------------------------------------------------

Table 2:

A B C
1 John Doe 1/18/2014 2/18/2014
2 Jane Doe 11/13/2014 11/14/2014

----------------------------------------------------------------

Now because John Doe's date ranges mix I want that row to turn red.