How do I shade a cell using custom number format codes.

[Pete_UK]

Use Format | Conditional Formatting.

Next time use this large white space to describe your problem, not
just the header.

Pete

 

[Bob Phillips]

You don't, custom formats can affect the font colour not the fill colour.