#1
|
|||
|
|||
Right and Left justification
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? |
#2
|
|||
|
|||
Use the Worksheet_Change Event (in the sheet module) to check for that column.
If not numeric then macro code to right justify, otherwise it will always be left justified. |
#3
|
||||
|
||||
Try removing all justification formats from that column, it should look after itself.
|
#4
|
|||
|
|||
Thank you
I was overthinking. So simple. Thank you.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
right to left and left to right icon missing in paragraph section | mh2019 | Word | 1 | 06-04-2019 11:53 AM |
Justification within a table | drgt | Word Tables | 6 | 12-30-2016 03:29 PM |
Justification | FredW | Word | 5 | 03-10-2016 05:39 PM |
Justification in tables | mminten | Word Tables | 1 | 10-26-2012 01:39 AM |
Justification not working right? | kmsimmonds | Word | 1 | 08-14-2012 04:35 AM |