Change:Code:If SourceData(ro, LevelColm) <> SourceData(rw, LevelColm) Then
to:to highlight Job Titles which exist on multiple Levels and/or multiple Categories.Code:If (SourceData(ro, LevelColm) <> SourceData(rw, LevelColm)) Or (SourceData(ro, CatColm) <> SourceData(rw, CatColm)) Then
Hi p45cal
Thank you for doing that, is it possible to have the coding do the following instead?
- colour code position titles that appear under more than 1 category only? (if they appear under the 1 category but under multiple levels this is ok)