Forum Discussion
Using formula function instead of conditional formatting
Can a conditional format be replaced with a if, then function containing cell formatting functions? If so, where can I get information and examples?
J2-____jj , formulas in Excel work with cells values, not with cells properties like format. To work with properties you may use VBA programming, or conditional formatting, or, in some extent, custom numbers formatting.