I want to use more than 3 conditions, I know that there is a way to use VBA
to do this but I have no idea of how to use vba. What I have is a list
contained in a cell from which the user picks a word and I want each word to
have an associated colour appear in another cell. I cant seem to understand
how the VB codes are supposed to work so i have not been able to adapt them
from other users suggestions
I cannot use the tool in www.xldynamic.com/source/xld.CFPlus as Im not
allowed to download it, also multiple users will need to use the s/sheet
What I need to do is when a user selects
"On track" in the list the corresponding cell in the work sheet needs to
turn green
"completed" needs to be blue
"overdue" needs to be red
"late" needs to be red
"problem" needs to be red
"Agreed" needs to be purple
"confirmed" needs to be purple
would greatly appreciate any help
Bookmarks