Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-14-2021, 08:56 PM
tcarnahan tcarnahan is offline A way to easily determine the formatting used in a cell Windows 10 A way to easily determine the formatting used in a cell Office 2019
Novice
A way to easily determine the formatting used in a cell
 
Join Date: Sep 2021
Posts: 1
tcarnahan is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 09-15-2021, 12:15 AM
wiganken wiganken is offline A way to easily determine the formatting used in a cell Windows 10 A way to easily determine the formatting used in a cell Office 2019
Competent Performer
 
Join Date: Jul 2018
Posts: 121
wiganken will become famous soon enough
Default

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?
Reply With Quote
  #3  
Old 09-15-2021, 10:41 AM
Purfleet Purfleet is offline A way to easily determine the formatting used in a cell Windows 10 A way to easily determine the formatting used in a cell Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 335
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Reply With Quote
  #4  
Old 09-16-2021, 02:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline A way to easily determine the formatting used in a cell Windows 7 64bit A way to easily determine the formatting used in a cell Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,480
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

You could use the old GET.CELL embedded macro Info only - get.cell arguments | MrExcel Message Board
BTA...
Reply With Quote
Reply

Tags
excel 2019 formatting

Thread Tools
Display Modes


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
A way to easily determine the formatting used in a cell 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
A way to easily determine the formatting used in a cell 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft