VLookup Red Text If Cell Text Is Not "Stål Ok"

[James2376]

Hey, how do i make it so that my Vlookup checks a cell for the text "Stål Ok" and if the cell text is something else then "Stål Ok" it takes that text and makes it red (It is normally a date. Example: "25.sep")

Would be super helpful if someone could help me with this. Thanks!


EDIT:
So basically what i want to use this for is to look up a production number with vlookup to see if column 16 on that line says "Stål Ok" (Means Steel OK) or if it says a date, because that means the steel is not ready yet. If it says Stål Ok everything is fine, but if it says a date like the example 25.sep (anything else then Stål OK) then i want it to say 25.sep or whatever it says in red text.

 

[awoohaw]

I'm not sure I have it all understood. But, it seems you want two things. A formula for looking up a value, and then conditional formatting depending on what the value the lookup returns. So that is what I think I'm doing here:

You need to take care of the NA() returns somehow. But try this as a start:

Mr excel questions 60.xlsm
	A	B	C	D	E	F
1	Prod Number	VLOOKUP
2	12721	#N/A
3	33794	25.Sep
4	34780	#N/A			33794	25.Sep
5	40170	#N/A			45575	Stål Ok
6	45575	Stål Ok			75875	24.Sep
7	56273	#N/A			77762	Stål Ok
8	75875	24.Sep			90085	27.Sep
9	77662	#N/A
10	83735	#N/A
11	90085	27.Sep
James2376

Cell Formulas
Range	Formula
B2:B11	B2	=VLOOKUP($A2,$E$4:$F$8,2,0)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B11	Expression	=IF(ISNA(B2)<>TRUE,B2<>"Stål Ok")	text	NO

 

[awoohaw]

@James2376 , was the suggestion helpful?

 

[James2376]

@James2376 , was the suggestion helpful?

Yes. Thank you for the help!

 

[awoohaw]

My pleasure. Welcome to the forum, and thanks for the feedback.

- Best Wishes!