SOLVED

GET.CELL Not Working

Copper Contributor

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?

3 Replies
best response confirmed by Cicciuzz (Copper Contributor)
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.

HansVogelaar_0-1710865422649.png

In cell B1, enter the formula =GetColor

HansVogelaar_1-1710865635983.png

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

 

@Hans Vogelaar 

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

Cicciuzz_0-1710924244449.png

 

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

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

Cicciuzz_0-1710926860549.png

 

1 best response

Accepted Solutions
best response confirmed by Cicciuzz (Copper Contributor)
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.

HansVogelaar_0-1710865422649.png

In cell B1, enter the formula =GetColor

HansVogelaar_1-1710865635983.png

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

 

View solution in original post