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
I need to setup automations based on a contract date that will notify me on a monthly/quarterly/annual basis so I can process paperwork at the appropriate time. Ideally, I'd like to set it up to send an email 90 days before that date. I have columns for the initial contract date and the frequency (one for the word…
I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no…
Good Morning, I was working too early and after vacation and deleted some needed information from a report and it changes all my workbooks. I did the download for the history however it doesn't show me the data that was in the cells. Is there any way to get that information?
