Microsoft Excel Conditional Formatting 1 of 3: The Basics - Wise Owl

preview_player
Показать описание

Рекомендации по теме
Комментарии
Автор

assume that I have names in a column and data validation for those names in other cell. whenever I select a name from the list I want the background color of the cell of that name in first column should be changed and I want different color for each name. and only selected name cell color should be changed. I need this to be happened only with excel I dnt want to use any vba

nnaarreesshh