Format a cell with a comment based on a comment in another cell

[Solved/Closed]
Report
Posts
1
Registration date
Thursday October 2, 2014
Status
Member
Last seen
October 2, 2014
-
 stevo -
Hi,

I need to format a cell with a comment based on a comment in another cell.

So cell A1 might ask a question like is the window clean? B2 will have a drop down box with Yes, No or NA and as the result of the answer cell C1 will bring up a comment like window clean if the answer is yes, windows require cleaning if no and NA if the answer is NA.
Have gone nuts trying to work this one out.

Pls help!!!

2 replies

Posts
1313
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
August 3, 2021
233
Hello Stevo,

Try the following formula:-

=IF(B2="YES","Windows are clean.","")&IF(B2="NO","Windows require cleaning.","")&IF(B2="NA","NA","")

I assume that your first row will have headers so paste the formula into cell C2.

Click on cell B2 and use Data Validation to create a drop down: go to the Data tab and in the Data Tools group, click on Data Validation and in the drop down that appears, click Data Validation. In the dialogue box that appears, choose "List" in the "Allow" drop down box. In the "Source" box, type in Yes, No, NA and then click OK. A drop down box should then appear in B2.

Type your questions, such as "are the windows clean?", in A2.

The 'reply' text in the formula can be changed to suit your requirements.

You will need to adjust the column widths to suit.

Hopefully, this may help you.

Cheers,
vcoolio
Hi,

Thanks for this it was what I was looking for but in the wrong place!!

Cheers

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!