I'm trying to write a VBA script that will look at a selected cell range, in this case E5:AS35 and change the cell background color based on the following:
1. If data in cell is right-justified, the cell will be red (color 3).
2. If data in cell is left-justified, the cell will be green (color 4).
3. If data in cell has strikethrough, irregardless of justification, the cell will be white (color 2).
I would imagine the code will require a manual sheet calculation based on UDF, but I would rather it be that than a macro I have to run. I'm not having any luck getting this to go, any suggestions?
Bookmarks