Excel Question

[jaredhmr]

In excel, I can make a drop list for a cell so that users can choose the correct item but of course they cannot manually type in an entry if they needed too.
Can you make it where they can choose an item from the drop-down list or also be able to type in their own entry?
Thanks

 

[sbunnag]

In MS Excel, I have question, how can I make a cell flashing with Red color if condition are met, Say

at cell A1 is =279
B1 is =12
I want to exam cell A1 if the B1 is > 10 and A1 < 280 then
make cell A1 flashing with the Red color ( I am reading real time data and calculate a value in cell B1 and read A1 as real time data) Using Format condition and Macro. I don't
how to activate macro automaticlly, if both condition are met.

Thanks,
S. Bunnag