Conditional Formatting
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. |
Conditional Formatting
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. |
Conditional Formatting
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. |
Conditional Formatting
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. |
Conditional Formatting
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 |
All times are GMT +1. The time now is 02:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com