![]() ![]() The CELL function has two arguments: INFO_TYPE and REFERENCE. However it is worth understanding the CELL function as this can be useful for applying conditional formatting to highlight cells with other attributes. TRUE is only returned if there is no text, formula or constant in the cell. ![]() The ISBLANK function is a simple test that exists in Excel® to return TRUE or FALSE. In fact there are 2 alternatives we could use. ![]() If you don’t want to highlight cells like this then we need an alternative function. There could potentially be a formula in cell B9 above that is returning “”. The COUNTIF function will include all cells that appear to be blank. ![]() If you clear out some of the other cells in colulmn B you will see they also turn yellow as expected. ![]()
0 Comments
Leave a Reply. |