I have drop down list to select in Excel cell, for ex: Yes, No, N/A. And I want when I select yes -- cell becomes red color, select No - blue and so on..
how i can do it?
I have drop down list to select in Excel cell, for ex: Yes, No, N/A. And I want when I select yes -- cell becomes red color, select No - blue and so on..
how i can do it?
use Format > Conditional formatting...
Thanks, it was easy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks