Forum Discussion
GET.CELL Not Working
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?
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.
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.
As said, I tried this solution but it doesn't work.
My Excel is in Italian, and CELLA = GET.CELL
Got the mistake. Wrong Formula
get.cell = info.cella
