Condtional formatting on 2 separate dates
 

I have a spread sheet that conatins hire dates in one column (A) and
termination dates in a separate column (AU). I want it to highilght the date
in column A if there is a termination date in column AU. Or even highlight
the name of the employee in column F if there is a termination date in column
AU. THANKS!!!

Condtional formatting on 2 separate dates
 

In F2 use a CF formula of

=ISNUMBER(AU2)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"mfoster" wrote in message
...
I have a spread sheet that conatins hire dates in one column (A) and
termination dates in a separate column (AU). I want it to highilght the
date
in column A if there is a termination date in column AU. Or even highlight
the name of the employee in column F if there is a termination date in
column
AU. THANKS!!!

Condtional formatting on 2 separate dates
 

:-) Worked perfect! Thanks!!

"Bob Phillips" wrote:

In F2 use a CF formula of

=ISNUMBER(AU2)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"mfoster" wrote in message
...
I have a spread sheet that conatins hire dates in one column (A) and
termination dates in a separate column (AU). I want it to highilght the
date
in column A if there is a termination date in column AU. Or even highlight
the name of the employee in column F if there is a termination date in
column
AU. THANKS!!!