I need to change the alignment of certain cells in a spreadsheet, based on
their content. For example, if the cell contains the text "Total", I need it
to be right aligned, but if it says "Department", I need it left aligned. I
can't see a way to do this using conditional formatting. Any ideas?