Condtional formatting on 2 separate dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mfoster - 19 May 2008 15:59 GMT

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!!!

Reply to this Message

Bob Phillips - 19 May 2008 16:45 GMT

In F2 use a CF formula of

=ISNUMBER(AU2)

Signature

---
HTH

Bob

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

>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
[quoted text clipped - 3 lines]
> column
> AU. THANKS!!!

Reply to this Message

mfoster - 19 May 2008 20:03 GMT

:-) Worked perfect! Thanks!!

> In F2 use a CF formula of
>
[quoted text clipped - 7 lines]
> > column
> > AU. THANKS!!!

Reply to this Message