Sign in to join the conversation:
Hello,
How can I get conditional formatting to apply to a cell that matches a value in a column? It only lets me highlight an entire row or column, not just the individual matching cell.
Hi,
When you set up the conditional formatting, you can click on the entire row portion of the text, and then you can choose which cell(s) in the row(s) matching the condition that should get formatted.
I hope this helps you!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
We changed from an enterprise licence to specific accounts. I have a licence and setup a workspace for our global team to edit and collaborate across various sheets. I granted editor can share rights to all non licensed members and shared the publish link with them. This has worked well and allowed them to edit cells,…
This is pulled from a column of responsible person. Why does it display email and not name. How do I correct?
Hi! I have a sheet that has two form that feed into it. This is to report on Closures due to Staffing, Weather, and Facilities. One team submits closures for Staffing and Weather, while another team only submits Facilities. When I created this set up I have it so the one team gets asked "Reason?" then they can select…