I am using Excel 2013. I have a column in a table that is defined as text. It will usually hold a whole number and I want it right justified. At times there will be text and I want this left justified. I have the column formatted as right justified. I had a brilliant idea to conditionally format it when it is not numeric as left justified. Unfortunately, that is not an option of conditional formatting.

Any ideas?