Conditional Formatting


S

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.
 
Ad

Advertisements

S

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top