Is there a way to make a named format applied to cells and then change that format and it cascade to all cells using that format? That way I can format certain numerical values and if the need changes I can just change the named format.
Have a look at Cell Styles.
To create one:
To modify your style/format:
Any changes you make to the style will automatically reflect on cells to which it's been applied.