Microsoft 365 and Office | Excel | Other | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Data Flagging
![](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)
Anonymous
Hi,
I have up to 15 columns of data from L onwards, and I'm trying to set up a flag column in column K. A red flag for when data drops 10 percentage points or more, and green when it increases by 10 percentage points or more. Is this possible? If so, can it resent every time I put the next set of data in.. e.g. when column N data is added.
Thanks in advance!
Microsoft 365 and Office | Excel | Other | Other
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.