Excel 2000 ... What I have
Col T ... contains values ... 0 & 1
Col AA ... contains dates ... mm/dd/yy
In Col AR I wish Conditional Formatting Formula for when
condition is:
Col T = 1
Col AA = date older than 3 years from Today.
Thanks ... Kha
Excel 2000 ... What I have
Col T ... contains values ... 0 & 1
Col AA ... contains dates ... mm/dd/yy
In Col AR I wish Conditional Formatting Formula for when
condition is:
Col T = 1
Col AA = date older than 3 years from Today.
Thanks ... Kha
one way:
CF1: Formula is =AND(T1=1, DATEDIF(AA1+1,TODAY(),"y")>=3)
In article <[email protected]>,
"Ken" <[email protected]> wrote:
> Excel 2000 ... What I have
>
> Col T ... contains values ... 0 & 1
> Col AA ... contains dates ... mm/dd/yy
>
> In Col AR I wish Conditional Formatting Formula for when
> condition is:
>
> Col T = 1
> Col AA = date older than 3 years from Today.
>
> Thanks ... Kha
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks