If you are trying to apply one of the conditional formats below, but it doesn't work, make sure that you don't have any special characters in the cell if you are using the number format.