o.k. but how do I code that in the IF statement.

"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?