You can use this format
Yes this format works check it once.
Home (tab) > Conditional Formatting > Manage rules > New Rule > Format only cells that contain > [Cell Value - equal to - Y] > Format [choose whatever you want]
Follow the steps from 'New Rule' again to do the other Conditional Format.
|