Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 02-29-2016, 10:16 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Disappearing Cells Issue (Possibly Related to Conditional Formatting) Windows 7 64bit Disappearing Cells Issue (Possibly Related to Conditional Formatting) Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

The first condition in your CF is that any "x" placed in col K in an even row number will, turn the corresponding background of the cell in col E to gray and the text font color to the same shade of gray.
So, the background becomes gray, borders disappear ( they are not kept in the re-formatting) and text has the same color as the background making it "invisible"

Change the fill colors and/or font colors of the CF to solve it ( and eventually add borders to the CF formatting
Attached Images
File Type: png Screenshot - 290216 - 18:10:05.png (58.1 KB, 18 views)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
 

Tags
conditional, disappear, formatting



Similar Threads
Thread Thread Starter Forum Replies Last Post
Disappearing Cells Issue (Possibly Related to Conditional Formatting) Conditional Formatting- Only format cells once data is entered chart3 Excel Programming 1 12-15-2015 11:26 AM
Mail Merge Formatting Issue with Conditional IFs robbeh Mail Merge 5 07-08-2014 07:39 AM
Disappearing Cells Issue (Possibly Related to Conditional Formatting) Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Excel Formula - Conditional replacement of cells mag Excel 0 10-27-2012 08:30 PM
Disappearing Cells Issue (Possibly Related to Conditional Formatting) Sharepoint, Template and Macro related issue Samiksha Word 1 08-03-2012 03:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:25 AM.


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