Get the detailed steps on my Conditional Formatting page.
But in my experience, I haven’t had this problem with formulas.There’s a quirk with Microsoft Excel 2010 (and possibly other versions) where custom number formats don’t get applied to existing data.
Pingback:
“Her decision to keep her relationship with Joe quiet is making her happy,” claims the source, “They have been getting to know each other slowly without any pressure.