I have a status column (A) which list values are set in column (AA). The values are Not Started, Started, Elements Defined, Validation Completed, Completed. As the user chooses the correct status from the drop down list in col A, I want the conditional formatting rule to change that into a Quarters Icon set icon sunch as a full circle for Completed, half circle for Elements Defined etc... Only way I can think of this working is using a formula, but not sure how to. Thanks in advance for your help.
Bookmarks