|It is not clear to me what you are trying to accomplish.|
In your post you say "highlight cell b2" 3 times, for 3 separate conditions. Is B2 the only cell that you want to highlight?
Then you specify 3 conditions (the selection of C2, D2 & E2) and end with "and like so on".
What specifically does "and like so on" mean? Are you saying that you want to highlight B2 whenever any cell in Row 2 is selected?
If so, what do you want to happen when a cell outside of Row 2 is selected? Should the highlighting of B2 be turned off?
Please supply some more details so that we have a clearer understanding of what you are trying to accomplish.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.