Program: Excel 2010:

Question:
If E6=text then delete the value of A6 in Cells B6:C100

Basically when text in E6 equals "text" then match all instances where A6 is found in B6:C100 and delete contents.

|  A Name  |  B Contents  |  C Contents  |  D Contents  |  E Values  |  
----------------------------------------------------------------------
|  Angel   |  Basic       |  Angel       |  D Contents  |  Defined   |  
----------------------------------------------------------------------  
|  Zeus    |  Zeus        |  Angel       |  D Contents  |  Defined   |  
----------------------------------------------------------------------  

In the above, Angel in row C2 would be deleted. Zeus in B3 would be deleted Below is the result:

|  A Name  |  B Contents  |  C Contents  |  D Contents  |  E Values  |  
----------------------------------------------------------------------
|  Angel   |  Basic       |              |  D Contents  |  Defined   |  
----------------------------------------------------------------------  
|  Zeus    |              |  Angel       |  D Contents  |  Defined   |  
----------------------------------------------------------------------  

Conditional formatting is preferred as it is a non Macro enabled book.

{Edit} Perhaps a formula that could be similar to: if e6='text' then if B6:C100 contain A6 "" so rather than deleting the cell contents it overwrites them with a "".

Thank you in advance.