I have a cell (E19) with the following conditional formatting:
Formula Is: =ISTEXT(E19)
Cell Value Is: greater than 10
If either of these conditions are met, the cell background is to be turned red.
Cell E19 has the following formula in it:
=IF(ISNUMBER(Data!E19),Data!E19,"")
... so if cell "Data!E19" has no data in it, a null value will be returned to cell E19.
The problem I have is that if there is a null value returned to E19, the background turns red, even though neither of the conditions is met. Anyone have any idea what I am doing wrong?
Formula Is: =ISTEXT(E19)
Cell Value Is: greater than 10
If either of these conditions are met, the cell background is to be turned red.
Cell E19 has the following formula in it:
=IF(ISNUMBER(Data!E19),Data!E19,"")
... so if cell "Data!E19" has no data in it, a null value will be returned to cell E19.
The problem I have is that if there is a null value returned to E19, the background turns red, even though neither of the conditions is met. Anyone have any idea what I am doing wrong?