fliter for colour text

[sony]

dear all.
Thank you very much for help so far,
may i ask one more simple question?
How to use filter to pick the text with a certain colour (e.g. red)? see below appreciate your advice.

Book13
	A	B	C	D
1	vdr
2	ASA
3	FIN
4	HAT
5	HEC
6	HKF
7	HKT
8	INS
9	LGE
10	OPR
11	PVI
12	SAM
13	SAN
14	SFI
15	STL
16	TEP
17	TKO
18	TTC
19	VSC
20	YTN
21	ZDL
22	ZEG
Sheet1

 

[Andrew Poulsom]

Is there a condition which causes the cell text to be red? If so what is it?

 

[sony]

there is specific excel condition tha the text in red. Those in red is problem vendors, i need to sort them out.

please help
tks

 

[Andrew Poulsom]

You could use conditional formatting to set the colour.

1. In cell B1 type "problem".
2. In the range B2:B22 type 1 if the vendor in column A is a problem.
3. Select range A2:A22 and choose Format, Conditional Formatting from the menu.
4. For Condition 1 set Formula Is and type

=B2=1

in the box to the right.
5. Click Format and set the Font colour to red.
6. Click OK twice.

Now you can Autofilter columns A and B where problem = 1.

Hope this gives you some ideas.