Condition formatting wit a lil twist

[Soldier99]

I am looking to CF based on the values in two other cells. But first I need to find the number within one column to another than format base on the third

I have figured out how to CF on column to another (=COUNTIF(C:C,RIGHT(A1,5))) which works but I need I to format based on the third cell I have stumbled here

so in a nut shell I need to find values from column C in column A and format A based on Column C (red for grd, yellow for outu, and green for serv)

I hope that makes sense oh yeah BTW I am using 2003 currently and upgrading to 2010 in about a year.

Thank you in advance

a	b	c	d
1983-60389		00717	OUTU
1989-92345		99912	OUTU
1993-97517		99603	GRD
2004-48030		99131	GRD
2004-48040		98664	OUTU
2004-63546		98518	GRD
1983-62265		98505	SERV
1993-98664		98503	GRD
1989-92300		98451	GRD
1989-92322		98341	OUTU
1993-98341		60389	GRD
		92322	SERV
		92345	GRD

<tbody>
</tbody>

 

[konew1]

I don't have access to xl2003, but I remember it is different to xl2010.Try this
=AND(C1="GRD",COUNTIF(C:C,RIGHT(A1,5)) and select your formatting, then add another level and set up for SERV then again for OUTU

 

[DILIPandey]

Hi Soldier99,

Use below formula in conditional formatting under option "use a formula to determine which cell to format" :-

=VLOOKUP(RIGHT(A2,5)*1,$C:$D,2,0)="GRD"
and format fill as RED
do the same for Yellow and green as well with OUTU and SERV.

Regards,
DILIPandey

 

[Soldier99]

Thanks DILIPandey worked great

 

[DILIPandey]

You are welcome Soldier99.... Cheers


Regards,
DILIPandey