Hi guys, I just found out that it's possible somehow to colour a cell based on text value but WITHOUT using Conditional Formating (as this can slow down a file)

Do you know what custom formating code we would use to say:

IF cell value = "y" then cell colour is green
IF cell value = "n" then cell colour is red

Nothing comes up on Google on this one...

Thanking you in advance!