The IFS function much like the IF function, is used to conditionally format your data to various criteria, as if sheets had "rationale".