#1
|
|||
|
|||
A way to easily determine the formatting used in a cell
Hi!
I teach a class on Excel and have to grade many Excel files. I seem to remember in some bygone spreadsheet (Lotus, etc.), you could select a cell, then click on a button OR press a combination of shortcut keys. A dialog box would pop up and definitively identify all formats used in that cell. QUESTION: Is there such a feature in Excel 2019 / MS-Office 365 Excel to perform the same function? It would sure save a lot of time if I could easily id the fonts, formatting, conditional formatting, etc. without having to guess all of the time. Thank you ahead of time for any help you can provide! Tom |
#2
|
|||
|
|||
The formatting used in any cell is immediately visible in the top ribbon so you can see at a glance without pressing anything. I assume you have the ribbon displayed?
|
#3
|
|||
|
|||
There is a formula called CELL, but its not very helpfull in the real world.
Personally if it was a repetative task and fairly limited criteria i would write a macro to check each cell and provide output if not as expected |
#4
|
||||
|
||||
You could use the old GET.CELL embedded macro Info only - get.cell arguments | MrExcel Message Board
BTA... |
Tags |
excel 2019 formatting |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formatting unprotected cell in protected w/s makes the cell locked? | tango356 | Excel | 2 | 01-23-2017 02:13 PM |
Determine if a cell contains a 0 value | bgranzow | Word VBA | 1 | 01-07-2016 03:50 PM |
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting | hanvyj | Excel Programming | 0 | 08-28-2015 01:15 AM |
New to word: formatting a program with bios and pix; needs to be easily editable. Where to start?! | bgbg4us | Word | 1 | 04-02-2015 11:06 PM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |