Tag Info

Hot answers tagged


In a quick test, I was able to accomplish what it sounds like you are wanting with the following. Using CTRL + Left Mouse Click, Highlight one rows worth of cells that you want included in the validation; F, J, and N in your example. Go to the Format menu and choose Conditional Formatting In the Conditional format rules pane, change the "Format cells ...

Only top voted, non community-wiki answers of a minimum length are eligible