Hi Max, Thanks!
If I have multiple parameters, i.e. "Pipe","Duct","Tray", how can I join
that together in the IF statement, to be true?
Cheers,
Ando

"Max" wrote:

Select B3, apply CF using Formula Is:
=A3="Pipe"
Format to taste Ok out
voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Steve HKG" wrote:
If cell A3 contains the word "Pipe", then I want cell B3 to be blacked out.
I have been trying to use the Conditional Format tool with the formula

=IF(A3="Pipe","","")

but it does not seem to work. Can anyone advise, how I can get the cell to
turn black when I set the fill for the true condition to be Black.

Many thanks.