GET.CELL Not Working

[Cicciuzz]

Hello Everyone,

i'm trying to use and IF statement based on Background Color of a CELL.

Reading on web, I found the formula =GET.CELL(63,RIF) to get the color code.

Tried on a cell, but i get an error #VALUE.

If I read the specification of the function, I get some option text based, but not numbers.

I'm thinking that the function is either deprecated or changed.

What do your think?

[#2 · Accepted solution]

@Cicciuzz 

GET.CELL is an Excel 4 macro function. You cannot use it directly in a cell formula.

Let's say you want a formula to return the color index of the cell to the left.

Select B1 on Sheet1.

On the Formulas tab of the ribbon, click Define Name.

Enter GetColor in the Name box, and the formula =GET.CELL(63,Sheet1!A1)

Click OK.

In cell B1, enter the formula =GetColor

Remark: Excel will not automatically update the result of the formula when you change the fill color of a cell.

[#3]

@HansVogelaar 

As said, I tried this solution but it doesn't work.

My Excel is in Italian, and CELLA = GET.CELL

[#4]

Got the mistake. Wrong Formula
get.cell = info.cella