Conditional format blank cells that has formulas that returns blank values

[lawi227]

If a cell in column A is not blank, then I want to format the adjacent cell in column L to be blue. The tricky part is there is a formula in column A in each cell. This is the formula: {=IFERROR(INDEX('FullList (selectLPs)'!B$2:B$658,SMALL(IF('FullList (selectLPs)'!$A$2:$A$658="X",ROW('FullList (selectLPs)'!$A$2:$A$658)-1),ROW(3:3))),"")}

Therefore, although the cell might appear blank, it actually has a formula in it. So my conditional formatting always changes column L cells to blue, regardless if it appears column A is blank (but really there is a formula).

I used this formula originally but it does not work for condiitonal formatting: =NOT(ISBLANK($A2))

Thanks

 

[63falcondude]

Try =$A2<>""

 

[Legacy 396030]

I agree with 63falcondude it seems to work. When data fills a cell in column A the adjacent cell in column L turns to the color selected.

 

[lawi227]

Try =$A2<>""

Thanks! This worked!

 

[63falcondude]

Thanks! This worked!

You're welcome. The difference is between a blank cell and an empty cell. ISBLANK returns TRUE if the cell is truly empty (i.e. has nothing in it). I think the function would be better named ISEMPTY.