This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Good Evening,
Can someone help me? I am trying to have a cell show a dash if a certain condition is met by another cell as well as highlight based on that same cell. For example, from the table below using John Doe as an example. If Certificate column show Certificate 1 or 2, Course should show as a dash. If enrolled is the Certificate column cell value as with Tom Jones and Samantha Harley, nothing should occur in the course column. I know how to highlight the row based on the certificate cell value but unsure how to change or not change the course column based on the certificate value.
| Name | ID | Course | Certificate |
|---|---|---|---|
| John Doe | 12345 | Course 1 | Certificate 1 |
| Jane Doe | 54321 | Course 1 | Certificate 2 |
| Tom Jones | 56789 | Course 2 | Enrolled 1 |
| Samantha Harley | 98765 | Course 2 | Enrolled 1 |
Sincerely,
Yve
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
Write this formula in cell E2 and drag down
=if(or(D2="Certificate 1",D2="Certificate 2"),"-",C2)
Hope this helps.