Format a cell with a comment based on a comment in another cell
Solved/Closed
stevo5355
stevo - Oct 12, 2014 at 08:33 PM
- Posts
- 1
- Registration date
- Thursday October 2, 2014
- Status
- Member
- Last seen
- October 2, 2014
stevo - Oct 12, 2014 at 08:33 PM
Related:
- Format a cell with a comment based on a comment in another cell
- Conditional Formatting: Highlight cells based on two values ✓ - Forum - Excel
- Conditional formatting excel cell color based on text in another cell ✓ - Forum - Excel
- Conditional formatting if cell contains date - Guide
- Conditional formatting if cell contains text ✓ - Forum - Excel
- Excel count conditional formatting color cells - Forum - Excel
2 replies
vcoolio
Oct 3, 2014 at 02:43 AM
- Posts
- 1345
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 20, 2022
Oct 3, 2014 at 02:43 AM
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
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