Conditional Formatting

[Steve HKG]

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.

 

[Gord Dibben]

Select B3 and CF>Formula is:

=A3="Pipe"


Gord Dibben MS Excel MVP

 

[Max]

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]

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]

You could use this as the CF formula in B3:
=OR(A3="Pipe",A3="Duct",A3="Tray")
any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik