Applying a style from the style gallery using conditional formatting

mmcksmith No, conditional formatting is limited and you can only select from and use the interface supplied.  That said, you could consider setting a few 'generic' rules with corresponding format and just add cells, rows, columns, areas, etc to the conditional formatting 'applies to' section.  I'm not sure if it would help but you could also use defined names in addition to or instead of individual cell references in the 'applies to' section. So for example you can set up conditional formatting for 'overdue' to be red background with bold red font, etc... and applies to ConditionalRange and then define ConditionalRange in the Define Names section.  The tricky part is to remember that the relative reference in the conditional formatting is based on the upper left corner of the applies to range.  So you need to make sure you account for that either in the conditional formula also using the defined name or by the defined name always having the most upper left cell included.