GET.CELL

N

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
What is "GET"? I cannot find any explanation of the GET as used to precede the CELL function yet I found this post in the archives:

If you want to highlight cells containing formulas (without reverting to VBA !) Posted by Ian on September 28, 2001 9:28 PM

Define a name (let's say, HasFormula) and type in the refers to box =GET.CELL(48,INDIRECT("rc",FALSE))
Select the cells you want highlighted if they contain a formula. Go to conditional formatting, put in the FormulaIs box =HasFormula, and set your format.

I've also checked MS Excel Inside Out, Mr. Excel On Excel and other books.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Sort by date Sort by votes
Paddy: thanks. I tried searching for GET.CELL on this site but instead got instances of the words Cell and Get that weren't even next to each other in a contiguous string.

At least now I know what and how to use GET.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Highlight entire rows in used range where any cell contains searched text
Replies
5
Views
558
CorrieAnn
C
A
  • Question Question
Conditional formating (with range) but instead of the color/formating of the certain cell to get values inside the matching cells in the range?
Replies
1
Views
391
aircarrier
A
MrDB4Excel
  • Solved
DuckDuckGo Conditional Format
2
Replies
12
Views
813
MrDB4Excel
MrDB4Excel
N
  • Question Question
Finding consecutive(-ish) blank cells
Replies
3
Views
721
Eric W
Eric W
D
  • Solved
VBA User Form Code Issues in MS 365
Replies
6
Views
722
Fluff
Fluff

Forum statistics

Threads
1,224,352
Messages
6,178,064
Members
452,822
Latest member
MtC

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top