Multiple conditions (from different columns) applying conditional formatting
1 Can I do conditional formating using more than one criteria (different Columns)
We track goals for residents and if the goal is not met within the required timeline I would like it to highlight the total in red.
is there a way to make 2 conditions for the same formatting rule? example if frequency is '30X/Month' and month column is <30, highlight red
If Frequency is '4X/month' and month Column is '<4' turn background red or highlight red
etc for 1X/Month
Help Article Resources
Check out the Formula Handbook template!