Are you sure that alignment can be used as a result of conditional
formatting, Sheeloo? Which version of Excel? I can't find any such ability
in Excel 2003.
--
David Biddulph

Sheeloo wrote:
Use conditional formatting...
Choose one format for one result and another for another result

"kpt" wrote:

I want the alignment for a cell to be right justified for one result
of the if statement, but left justified for the other result. Any
ideas?