Show warning for Yes

[rohit_ranjan1]

Hi, is there a way to show warning when yes is selected from yes, no drop-down list (without using macros).

 

[nemmi69]

use conditional formatting like this

 

[Scott Huish]

The Upper isn't necessary, (=$A1="yes") but if you just want to hightlight that columns values, you can do it this way:

Select Column. Go into Conditional Formatting: