You can use the IF statement alongside Excel's conditional formatting to change the cell's color based on conditions. You can ...

For example, if a is (A1), this will return TRUE, but if a is ("apple"), this will return FALSE. Even though they start with IS, the ISPMT and ISOWEEKNUM functions are not part of the IS group.