Project finance

pdvsa

<div>
Hi Tom, I tried that but it shades cells that contain the text only. &nbsp;i need to shade other cells in the same row and not the cells trhat contain the text. &nbsp;<br>For example<br>cell E6 contains the word building so shade cell L6 purple. &nbsp; I dont want to shade cell E6. &nbsp;Only L6.&nbsp;
</div>


<div>
so basically highlight every cell in Column L &nbsp;based on the criteria for column E.&nbsp;
</div>


<div>
Oops, my mistake. Not at a computer at the moment. Thinking IF statement.
</div>


Eric Fletcher

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I &nbsp;need to set up a conditional formatting to shade cells in Col L purple for any corresponding cell in Col E that contains the word &quot;Building&quot;. &nbsp;How can i do that? &nbsp;<br />
<br />
for example<br />
cell E6 contains the word building so shade cell L6 purple. &nbsp;<br />
<br />
thank you
</div>
</div>


Experts,

I  need to set up a conditional formatting to shade cells in Col L purple for any corresponding cell in Col E that contains the word "Building".  How can i do that?  

for example
cell E6 contains the word building so shade cell L6 purple.  

thank you


Hi Tom, I tried that but it shades cells that contain the text only.  i need to shade other cells in the same row and not the cells trhat contain the text.  
For example
cell E6 contains the word building so shade cell L6 purple.   I dont want to shade cell E6.  Only L6. 


so basically highlight every cell in Column L  based on the criteria for column E. 

Oops, my mistake. Not at a computer at the moment. Thinking IF statement.

Conditional Formatting  - shade cell based on value of another cell

Experts,

I  need to set up a conditional formatting to shade cells in Col L purple for any corresponding cell in Col E that contains the word &amp;quot;Building&amp;quot;.  How can i do that?  

for example
cell E6 contains the word building so shade cell L6 purple.  

thank you

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

Microsoft Word

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.