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.

Select B3 and CFFormula is:

=A3="Pipe"


Gord Dibben MS Excel MVP

On Fri, 16 Oct 2009 13:26:01 -0700, 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.

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.

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.

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
---
"Steve HKG" wrote:
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