Conditional formatting

[Eric Tsang]

Dear Sir

Can you help

I have two data sources, one is input (d1) , then the data sources (A1:B5)

if the "text"that match the value in "D1", then turn to black

Hope you can help
Eric

[Special-K]

Select A8:B21

Conditional Formatting
New Rule
Use a formula to determine...

=(A8=$D$8)

Format as required

[The_Snook]

Hi Eric,

Does the attached cover what you need? I've simply amended your attempted conditional format.

Regards,

Snook

[sandy666]

Brackets are not necessary