/ More Excel questions: Reading cell formatting on mass
Is there any way of highlighting what formatting is in use in a cell, to compare sheets of similar looking data? I know you can highlight numbers stored as text using the error checking options but can I tell the difference between 0.9, 0.85 (1dp), 0.90 and 0.9 (stored as text)?
using =Sheet1 A1 = Sheet2 A1 etc isn't descriminating enough :-(
Ideally I either need to output these differences in conditional formatting (ie. Numbers stored to 1dp in blue) or spitting out a numeric value for the formatting that I can play with in a function. (I know you can read cell colours with some VBA code).
this gives you the list of potential outputs and also other choices.
Only question would be how it deals with custom categories.
If i was dealing with millions of cells though i would be tempted to go the vba route from the outset. Otherwise you would need to set auto calc on and off as needed which is a pain.
Cheers my Googling skills are obviously weak this morning, I should have spotted that!
(Un)fortunately it is not my data so there are limits on what I can do with it, also I have to explain any changes I make and I don't want to explain VBA unless I absolutely need to :-)
Just spotted the lack of irritating lack of updating. I can always work around that though!
Elsewhere on the site
F ounded in 1993, Mountain Hardwear are a pretty young mountaineering clothing and equipment manufacturer but are also one of... Read more
Perhaps the perfect Xmas gift for the climber in your life... Wild Country's Crack School has two of the worlds best crack... Read more
Tonight's Friday Night Video features the Norwegian town of Rjukan, once believed to be the home of the world's tallest... Read more