Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2022, 08:34 AM
herosz herosz is offline Selected cell's color meaning Windows 7 64bit Selected cell's color meaning Office 2016
Novice
Selected cell's color meaning
 
Join Date: Oct 2019
Posts: 27
herosz is on a distinguished road
Default Selected cell's color meaning


Hy!
I have a table and when select different cells I get some different colors as in the attached image. Please someone explains the meaning of different colors or guides me toward a documentation.
Thank's
Attached Images
File Type: png word1.png (34.3 KB, 11 views)
Reply With Quote
  #2  
Old 02-15-2022, 04:03 PM
Guessed's Avatar
Guessed Guessed is offline Selected cell's color meaning Windows 10 Selected cell's color meaning Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Shading inside cells can be applied at the Cell, Paragraph and Text level.

Judging from the graphic, I would say your paragraphs inside the table cells are set to be shaded. The white areas are inside the cell but outside of the shaded paragraph region.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 02-16-2022, 07:22 AM
herosz herosz is offline Selected cell's color meaning Windows 7 64bit Selected cell's color meaning Office 2016
Novice
Selected cell's color meaning
 
Join Date: Oct 2019
Posts: 27
herosz is on a distinguished road
Default

no, in Shading for the paragraph I have:
  • Fill: No color
  • Style: Clear
similarly for the table and the cell shadings. Also I pressed Ctr+Q to remove all cell's paragraph formatting.

Last edited by herosz; 02-16-2022 at 01:16 PM.
Reply With Quote
  #4  
Old 02-16-2022, 02:28 PM
Guessed's Avatar
Guessed Guessed is offline Selected cell's color meaning Windows 10 Selected cell's color meaning Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Can you post a document with your shaded table? It is easier to diagnose when we can see the actual file.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 02-17-2022, 05:09 AM
herosz herosz is offline Selected cell's color meaning Windows 7 64bit Selected cell's color meaning Office 2016
Novice
Selected cell's color meaning
 
Join Date: Oct 2019
Posts: 27
herosz is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
Can you post a document with your shaded table? It is easier to diagnose when we can see the actual file.
Of course, thank you for help!
.
Attached Files
File Type: docx Doc2.docx (13.8 KB, 10 views)
Reply With Quote
  #6  
Old 02-17-2022, 02:47 PM
Guessed's Avatar
Guessed Guessed is offline Selected cell's color meaning Windows 10 Selected cell's color meaning Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

OK, I see it is the selection shading rather than the applied shading. You are seeing the shaded area of where the paragraph in the cell is sitting. The first columns have 12pt text while the next columns have 10pt text. Generally both these don't have paragraph spacing above or below so the smaller text cells take up less vertical space than the 12pt cells.

The table is mainly using auto row heights so the tallest paragraph determines how tall the row is. If the row is autoheight then at least one of the rows will be fully shaded. The first row is set to "At Least" greater than the paragraphs inside it so the selection shading sits at the top of the cells in that row.

In the case of the 5th row, the 3rd cell has space above/below added to the paragraph so it is taller than in earlier rows.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 02-20-2022, 12:26 PM
herosz herosz is offline Selected cell's color meaning Windows 7 64bit Selected cell's color meaning Office 2016
Novice
Selected cell's color meaning
 
Join Date: Oct 2019
Posts: 27
herosz is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
The table is mainly using auto row heights so the tallest paragraph determines how tall the row is..
I agree this, but if I leave only one cell per line why the cell with spacing zero is half colored and the cell with existing "spacing after" is full colored?
.
Attached Files
File Type: docx 3.docx (13.2 KB, 12 views)
Reply With Quote
  #8  
Old 02-20-2022, 02:56 PM
Guessed's Avatar
Guessed Guessed is offline Selected cell's color meaning Windows 10 Selected cell's color meaning Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Quote:
The table is mainly using auto row heights so the tallest paragraph determines how tall the row is. If the row is autoheight then at least one of the rows will be fully shaded. The first row is set to "At Least" greater than the paragraphs inside it so the selection shading sits at the top of the cells in that row.
Your sample document has a two cell table where the first row is set to autoheight and the second row is set to At Least 0.97cm. The first half of the second row shows shading because that is where the paragraph space is, the lower half doesn't show shading because that space is there because of the row height restriction.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selected cell's color meaning Paste value of selected cell to adjacent cell Marcia Excel Programming 3 08-26-2021 12:55 AM
Cell text color vs cell background color AC PORTA VIA Excel Programming 4 12-19-2018 04:01 PM
Macro to change an RGB table cell shading color to another RGB color David Matthews Word VBA 4 05-29-2018 02:45 PM
Setting a particular table cell background color when an option button is selected in Word 2007 a888 Word VBA 11 03-25-2015 05:33 AM
Change cell color everytime a value is selected in dropdown list angelica_gloria Excel 4 01-27-2012 06:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:29 AM.


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