I have a conditional format on cells to remain white when the cell is blank using this:
=ISBLANK(OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,0))
However in some of the cells I have the following formula:
=IF(C14="","",IF(ISERROR(SEARCH("*Platform*",C14,1)),"N","Y"))
I need my ISBLANK to treat the cells where the result is "" as blank cells. Visually they are blank, but not in Excel's eye So the column that has that formula in it moves on to the next conditional format and fills the cell grey. This greying should only take place when a cell has an actual value.
Can anyone help?
=ISBLANK(OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,0))
However in some of the cells I have the following formula:
=IF(C14="","",IF(ISERROR(SEARCH("*Platform*",C14,1)),"N","Y"))
I need my ISBLANK to treat the cells where the result is "" as blank cells. Visually they are blank, but not in Excel's eye So the column that has that formula in it moves on to the next conditional format and fills the cell grey. This greying should only take place when a cell has an actual value.
Can anyone help?