Forum Discussion
Solved
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 but not even close. Can anyone help me, pls? Thank you very much！
See the attached sample workbook. Select Conditional Formatting > Manage Rules... to see the rule that I created.
7 Replies
Please explain in detail which colors you want for which conditions.
- 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 the regarding date in text or fill, color doesn't matter. I want to learn the way to do it. Tks~
See the attached sample workbook. Select Conditional Formatting > Manage Rules... to see the rule that I created.
- 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~
