CF Shading Cell With Red

[muhammad susanto]

hi all...

how to highlighted cell with red if :
if in name contains first word "s"---so highlighted with red in adjacent cell (in col.cf)

<tbody>
[TD="bgcolor: #FFFFFF"] name [/TD]
[TD="bgcolor: #FFFFFF"] cf [/TD]

[TD="bgcolor: #FFFFFF"] saluran terbuka [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF0000]#FF0000[/URL] , align: right"] [/TD]

[TD="bgcolor: #FFFFFF"] saluran tertutup [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FF0000]#FF0000[/URL] , align: right"] [/TD]

</tbody>

m.susanto

 

[muhammad susanto]

i hope this make clear :

<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style><!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">name</font></td>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">cf</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">saluran terbuka</font></td>
<td bgcolor="#FF0000" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">xxx</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">saluran tertutup</font></td>
<td bgcolor="#FF0000" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">xxxxx</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">BOX CLUVERT</font></td>
<td bgcolor="#FFFFFF" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">dadad</font></td>
</tr>
</table>





[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH][/TH]
[TH][/TH]
[/TR]
</thead><tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Excel Workbook
	A	B
1	name	cf
2	saluran terbuka	xxx
3	saluran tertutup	xxxxx
4	BOX CLUVERT	dadad
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2	1. / Formula is =LEFT(A2,1)="s"	Abc

 

[muhammad susanto]

hi peter...thank you but i miss it, should be 2 criteria
contains first word "s" AND contains word "LAND" in cell B2
i mean in cell A2 = contains first "s" and cell B2=contains exactly"LAND", then shading Red in cell B2

 

[Peter_SSs]

hi peter...thank you but i miss it, should be 2 criteria
contains first word "s" AND contains word "LAND" in cell B2
i mean in cell A2 = contains first "s" and cell B2=contains exactly"LAND", then shading Red in cell B2

Nothing like that mentioned in the original post?
Any realistic sample data and expected results?