Tech Support Guy banner
Status
Not open for further replies.

Solved: Conditional formatting isblank to ignore formulas

12K views 2 replies 2 participants last post by  martinbanks 
#1 ·
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?
 
#2 ·
So instead of testing for blank or empty string "" value why don't you evaluate the length of the cell using the LEN function? If the cell contains a formula only the LEN function should return a 0 value. If the formula returns an actual value the LEN function should evaluate to a number greater than 0.

Rollin
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top