Forum Discussion
brodskyfu
Oct 09, 2024Copper Contributor
How to conditional format in a dynamic spill?
Hi, I want to spill a date list according to Name in a row (maybe Filter is not the best, any better formula?), and some color to format according Type condition. I tried many formulas in the rule bu...
- Oct 09, 2024
See the attached sample workbook. Select Conditional Formatting > Manage Rules... to see the rule that I created.
HansVogelaar
Oct 09, 2024MVP
Please explain in detail which colors you want for which conditions.
brodskyfu
Oct 09, 2024Copper Contributor
I want to show someone's attendance date list under a specific name, if that day's class type is B, for example, highlight color in text or fill doesn't matter. Tks~