Conditional FormattingUpload ImagesLink Anthony P Mitchell 2 years ago
Hello Richard, another question if I may? In my Genealogy database on the PersonF page I have added a Combo box which shows the relationship of all the individuals to the "Home Person", I am the Home person. So for example when the person page is opened on my Father in the Combo box up comes the word "Father", for the individual Charles, my Granddad comes up in the Combo box, so I can see what relationship every one is to me. Now what I have tried to do is Color Code the individuals in the Combo box to show for example, Descendants, ancestris, Not related etc. but am unable to do this! I am not using VBA and I cannot get this to work, any advice would be appreciated, thank you.
You shouldn't need VBA to do this, just some conditional formatting. You may need to use an expression though because it sounds like you want to format based on the value in a different column of the combo box (descendant or ancestor). See this video on Conditional Formatting with an Expression.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
