<div>
Thanks Barry. &nbsp;My problem is I cannot get to any window that allow me to put in your suggestion.
</div>


Thanks Barry.  My problem is I cannot get to any window that allow me to put in your suggestion.

<div>
Thanks Barry for a speedy and accurate reply.
</div>


Thanks Barry for a speedy and accurate reply.

<div>
Which version of Excel are you using? Assuming Excel 2007 or later follow these steps:<br />
<br />
Select column B<br />
<br />
On &quot;Home&quot; tab select &quot;conditional formatting&quot; in the middle of the &quot;ribbon&quot;and then &quot;New Rule&quot; and &quot;Use a formula to determine which cells to format&quot;<br />
<br />
Type or paste my suggested formula in the box and then choose the required formatting<br />
<br />
Click OK and you're done.....<br />
<br />
regards, barry
</div>


Which version of Excel are you using? Assuming Excel 2007 or later follow these steps:

Select column B

On "Home" tab select "conditional formatting" in the middle of the "ribbon"and then "New Rule" and "Use a formula to determine which cells to format"

Type or paste my suggested formula in the box and then choose the required formatting

Click OK and you're done.....

regards, barry

<div>
<div class="content wysiwyg-content">
In a spread sheet I am working with I have two columns; names and positions. &nbsp;The first contains the name of an individual filling the position in the second column. &nbsp;If the first column is &quot;NOT FILLED&quot; I have already formatted its fill to be grey. &nbsp;I want to format the position associated with the at cell to be the same fill color.<br />
Is conditional formatting the solutions and if so how would I do that?<br />
Thanks in advance...<br />
Marvin
</div>
</div>


In a spread sheet I am working with I have two columns; names and positions.  The first contains the name of an individual filling the position in the second column.  If the first column is "NOT FILLED" I have already formatted its fill to be grey.  I want to format the position associated with the at cell to be the same fill color.
Is conditional formatting the solutions and if so how would I do that?
Thanks in advance...
Marvin

Excel Conditional Formating

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