Conditional formatting - Cells with formula vs normal cells

[Khalabeeb]

Hi everyone,

I created the following formula to put in conditional formatting (the cell number A7 is an example):

=ISNA(FORMULATEXT(A7))

Extended in a table of number, it will highlight the cells that do not contain a formula (i.e. figures that were entered manually).

However, if a part of the table where the conditional formatting is applied is blank, the cells will be highlighted... Is there a way to change the formula to NOT highlights blank cells?

Thanks in advance

 

[JoeMo]

Try:

=AND(A7<>"",ISNA(FORMULATEXT(A7)))

 

[Khalabeeb]

Thanks! It works really well.

 

[JoeMo]

you are welcome - thanks for the reply.