#3,020 in Computers & technology books
Use arrows to jump to the previous/next product
Reddit mentions of Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel
Sentiment score: 1
Reddit mentions: 1
We found 1 Reddit mentions of Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel. Here are the top ones.
Buying options
View on Amazon.comor
- Used Book in Good Condition
Features:
Specs:
Height | 9 Inches |
Length | 7.5 Inches |
Number of items | 1 |
Release date | April 2009 |
Weight | 1.15963149812 Pounds |
Width | 0.8 Inches |
Okay, I came across this trick while reading Excel Gurus Gone Wild. Great book written by Mr Excel,with some neat solutions to some challenging Excel issues. Anyway, a question I routinely see asked (and apparently is routinely asked in the Mr. Excel Forums) is how do I get the interior color or can I conditionally format based on color. This trick uses an arcane function, that can't be used in a regular cell based formula, but can be used in the Named Formula (or Name Manager) box. /u/takin_it_sleazy threw up some great code the other day for pulling it in via a custom UDF in VBA, found here. Anyway, I know many people try to avoid VBA for a variety of reasons, and so I thought this was a cool approach. Don't know how well it works, it may be buggy, but I did get it to work when I tried, as shown in the GIF. The named formula = GET.CELL(63,INDIRECT("RC",0)) The 63 references the interior cell fill color. The Indirect("RC",0) basically tells Excel to look in the same cell the formula is in, which works well for conditional formatting. For some reason, I think this may mute the color codes to either one of the older version of Excel's limitations, so 65 or 256, if memory serves. I just added the 4 cells with the GetFillColor formula to see what the codes the function picked up were. Note that the GET.CELL function returns a whole ton of info about the cell, hard to find on the web, but I did find it here. Obviously, it would be great to be able to use these without creating the named formulas, but it doesn't seem to be possible. Anyway, I thought it was cool enough that you might be interested to see it, give it a try. Good luck.