Conditional Formatting Across Workbook
Posted on 2014-02-11
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