You can do this with a formula in column C

For example, in C2

=if(B2="","",if(B2=12,True,False))

You can also shorten it to
=if(B2="","",if(B2=12,True))

--
Regards,
Tom Ogilvy


"Surya" wrote in message
...
Hi,

I am new to programming and I would like to know how to
do some automation in MS-Excel.

For example in Column A I would type some questions for
which user need to answer in column B for each question.
When they answer a question and leaves the cell I should
be able to evaluate whether the answer is true or false
and display the same in Column C.

When user open the excel file user will be seeing only
question in column A, when he types in answer in Column B,
it has to evaluated and result has to be displayed in
column C
A B C
No. of Months in a Year 12 true
No. of weeks in a Year 2 false

Could someone help me out with an example or links to
help me know how to achieve this kind of requirement