Off Belay forum


View latest messages in My Forums
This topic has been archived, and won't accept reply postings.

Topic - More Excel questions: Reading cell formatting on mass

mkean - on 12 Mar 2013
I've got a few massive spreadsheets (think millions of cells not thousands). These have text in, numbers stored as text, numbers stored to 1dp, numbers stored to 2dp, dates, times and all manner of other stuff.

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).

Cheers!
... not showing 4 replies to this topic ...
Register as a New User or login to gain full access to the forums. Registration is quick and completely free.
If you are definitely logged on, press Ctrl+F5 keys to reload this page [read more]

Unregistered users can only read messages in the most recent topics.

This topic has been archived, and won't accept reply postings.

My Forums