Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Information Functions

 

=CELL(color, B3) tells whether B3 is formatted for color-negative numbers

If true, a 1 is returned; otherwise, a 0 is returned. Input the formula: =CELL("color", B3). Press Enter to get the result.