conditional formatting

[zoinc]

Name	purchase 1	purchase 2	purchase 3	Amount	customer since	years membership
Abricht <colgroup><col></colgroup><tbody> </tbody>	1 <colgroup><col></colgroup><tbody> </tbody>	4	0	$291 <colgroup><col></colgroup><tbody> </tbody>	6/7/1994 <colgroup><col></colgroup><tbody> </tbody>	23 years
Annijs	0	7	0	$495	9/9/1986	30 years
Bingen	1	2	3	$420	2/14/1983	24 years
Callens	9	5	6	$280	12/14/1997	19 years

<tbody>
</tbody>

Really sorry for my Table, I'll make something much better next time just need some more practice....
I simply can't manage to use conditional formatting just with one column using another has a reference

In column A. Mark the names of the customers with a light green fill when they are a member for 15 years or more.
Mark the names of the customers with a light yellow fill when they are less than 15 years a member.

Can someone give me a hand with this? I'm kind of desperate...thank you

 

[arthurbr]

After selecting the A column
CF for green =and($G2<>"",(left($G2,2)+0)>=15)
CF for yellow =and($G2<>"",(left($G2,2)+0)<15)

 

[jarjarbingie]

Name	purchase 1	purchase 2	purchase 3	Amount	customer since	years membership
Abricht <tbody> </tbody>	1 <tbody> </tbody>	4	0	$291 <tbody> </tbody>	6/7/1994 <tbody> </tbody>	23 years
Annijs	0	7	0	$495	9/9/1986	30 years
Bingen	1	2	3	$420	2/14/1983	24 years
Callens	9	5	6	$280	12/14/1997	19 years

<tbody>
</tbody>

Really sorry for my Table, I'll make something much better next time just need some more practice....
I simply can't manage to use conditional formatting just with one column using another has a reference

In column A. Mark the names of the customers with a light green fill when they are a member for 15 years or more.
Mark the names of the customers with a light yellow fill when they are less than 15 years a member.

Can someone give me a hand with this? I'm kind of desperate...thank you

highlight the names, go to Conditional Formatting -> New Rule -> Use a formula

=DATEDIF($F2,TODAY(),"Y")>=15

 

[MARZIOTULLIO]

CF

=SUBSTITUTE(VLOOKUP(A2,$A$2:$G$5,7,FALSE),"years","")*1<15 applies =$A$2:$A$5 yellow

=SUBSTITUTE(VLOOKUP(A2,$A$2:$G$5,7,FALSE),"years","")*1>=15 applies =$A$2:$A$5 green

 

[ttray33y]

Name	purchase 1	purchase 2	purchase 3	Amount	customer since	years membership
Abricht <tbody> </tbody>	1 <tbody> </tbody>	4	0	$291 <tbody> </tbody>	6/7/1994 <tbody> </tbody>	23 years
Annijs	0	7	0	$495	9/9/1986	30 years
Bingen	1	2	3	$420	2/14/1983	24 years
Callens	9	5	6	$280	12/14/1997	19 years

<tbody>
</tbody>

Really sorry for my Table, I'll make something much better next time just need some more practice....
I simply can't manage to use conditional formatting just with one column using another has a reference

In column A. Mark the names of the customers with a light green fill when they are a member for 15 years or more.
Mark the names of the customers with a light yellow fill when they are less than 15 years a member.

Can someone give me a hand with this? I'm kind of desperate...thank you

1.) select A2 > open Conditional Formatting > Use Formula > =$G2<15 > apply a format "color fills etc."
2.) select A2 > open Conditional Formatting > Use Formula > =$G2>=15 > apply a format "color fills etc."

use format painter to copy down.