<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
I have to conditionally format cells in excel. &nbsp;I usually use the conditional formatting option and apply;<br />
<br />
Cell Colour &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Criteria<br />
Green &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; Cell is equal to &quot;X&quot;<br />
Green &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cell contains Has Access<br />
Green &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; Cell is equal to &quot;Yes&quot;<br />
Red &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cell contains &quot;Cannot&quot; <br />
Red &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cell contains &quot;No Access&quot;<br />
Yellow &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; Cell contains &quot;Not Defined&quot;<br />
<br />
this is fine to do on a couple of sheets but now I have 52. &nbsp;Is there a way to apply the formatting to the entire workbook?<br />
<br />
Thanks - CS
</div>
</div>


Hi there,

I have to conditionally format cells in excel.  I usually use the conditional formatting option and apply;

Cell Colour	Criteria
Green	        Cell is equal to "X"
Green              Cell contains Has Access
Green	        Cell is equal to "Yes"
Red	                Cell contains "Cannot" 
Red	                Cell contains "No Access"
Yellow	        Cell contains "Not Defined"

this is fine to do on a couple of sheets but now I have 52.  Is there a way to apply the formatting to the entire workbook?

Thanks - CS

Conditional Formatting Across Workbook

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