<div>
Typo!<br />
<br />
2. =CompItemsDone&gt;0<br />
<br />
Chris
</div>


<div>
Thank you for the closure, but didn't you want further help on the matter of the color range ... I was pointing out the 'correct' approach being to ask two questions ... I wan't refusing to provide appropriate help here despite this. &nbsp;Basically I need further info on the setup from you to try and assist further.<br />
<br />
Chris
</div>


Thank you for the closure, but didn't you want further help on the matter of the color range ... I was pointing out the 'correct' approach being to ask two questions ... I wan't refusing to provide appropriate help here despite this.  Basically I need further info on the setup from you to try and assist further.

Chris

<div>
<div class="content wysiwyg-content">
I need a formula to plug into a cell in excel. I want the cell to contain the number 1 if any cell in a range of different cells is the color yellow. <br />
<br />
Also, I need a separate conditional formatting formula. I want to have a cell turn red if a different cell has a numerical value &gt;&nbsp;0. The name of that other cell is CompItemsDone. Right now, the formula that isn't working for me is: =&quot;CompItemsDone&gt;0&quot;<br />
<br />
Thanks.
</div>
</div>


I need a formula to plug into a cell in excel. I want the cell to contain the number 1 if any cell in a range of different cells is the color yellow. 

Also, I need a separate conditional formatting formula. I want to have a cell turn red if a different cell has a numerical value > 0. The name of that other cell is CompItemsDone. Right now, the formula that isn't working for me is: ="CompItemsDone>0"

Thanks.

Check to see if a color is in a range of cells

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