Excel – Useful Custom Cell Formats

Accounting Format

#,###.00_);[Red](#,###.00);-_)
#,###.00_);[Red](#,###.00);-_);[Red]"Invalid – numbers only "@

UK Bank Account Number

00000000

UK Bank Sort Code

000000

Day and date

ddd dd/mm/yyyy

Shortform day of the week (eg Sat) when applied to a cell containing a date

ddd

Longform day of the week (eg Saturday) when applied to a cell containing a date

dddd

Conditional formatting formula for banded rows

=MOD(ROW(),2)=0

Conditional formatting formula for banded columns

=MOD(COLUMN(),2)=0